and changes column attributes in an existing table. Adds, modifies, and drops integrity constraints from an existing table. Restriction: You cannot use any type of view in an ALTER TABLE statement.

The specified columns are dropped when the table is created. Indexes are not copied to the new table. Both of these forms create a table without rows. You can use an INSERT statement to add rows. Use ...