alter语法（Alter syntax）.docVIP

alter语法（Alter syntax） Usage of the alter statement Usage of the alter statement If you need to modify the structure, use the alter statement, as follows: The ALTER TABLE statement is used to modify the design of the existing table. Syntax: ALTER, TABLE, table, ADD, field, COLUMN, type[(size)] [NOT, NULL], [CONSTRAINT, index] ALTER, TABLE, table, ADD, CONSTRAINT, multifieldindex ALTER, TABLE, table, DROP, COLUMN, field ALTER, TABLE, table, DROP, CONSTRAINT, indexname Explanation: the table parameter is used to specify the name of the table to be modified. ADD COLUMN is the reserved word for SQL, which adds fields to the table. ADD CONSTRAINT is the reserved word for SQL, which uses the index to add indexes to the table. DROP COLUMN is the reserved word for SQL, which uses it to delete fields from the table. DROP CONSTRAINT is the reserved word for SQL, which uses the index to delete the index from the table. Field specifies the name of the field to add or delete. The type parameter specifies the data type of the new field. The size parameter is used to specify the length of the text or binary field. The indexname parameter specifies the name of the multiple field index to be deleted. Sql*plus or third parties can run SQL statements of the program login database: ALTER TABLE (table name) ADD (column name data type); ALTER TABLE (table name) MODIFY (column name data type); ALTER TABLE (table name), RENAME COLUMN (current column name), TO (new column name); ALTER TABLE (table name), DROP, COLUMN (column name); ALTER TABLE (current table name) RENAME TO (new table name); Such as: Alter, Table, Employ, Add (weight, Number (38,0)); Alter, Table, Employ, Modify (weight, Number (13,2)); Alter, Table, Emp, Rename, Cloumn, weight, To, weight_new; ALTER, TABLE, EMP, DROP, COLUMN, weight_new; ALTER, TABLE, bouns, RENAME, TO, bonus_new; Add a column: ALTER TABLE table name ADD (column name data type); Such as: ALTER, TABLE, EMP, ADD (weight, NUMBER (38,0)); Modify the data type o