When you alter the attributes of a column and an index has been defined for that column, the values in the altered column continue to have the index defined for them. If you drop a column with the ...

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 ...