Summary of ALTER TABLE Arguments

Go Up to Using ALTER TABLE

When you use ALTER TABLE to add column definitions and constraints, you can specify all of the same arguments that you use in CREATE TABLE; all column definitions, constraints, and data type arguments are the same, with the exception of the <operation> argument. The following operations are available for ALTER TABLE.

• Add a new column definition with ADD <col_def>.

• Add a new table constraint with ADD <table_constraint>.

• Drop an existing column with DROP <col>.

• Drop an existing constraint with DROP CONSTRAINT <constraint>.
• Modify column names, data types, and positions