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

Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions. To add, drop, or modify a ...