SQL supports several statements for deleting existing metadata:
DROP TABLE, to delete a table from a database
DROP VIEW, to delete a view definition from a database
DROP INDEX, to delete a database index
ALTER TABLE, to delete columns from a table
For more information about deleting columns with
ALTER TABLE, see Altering a Table.