Dropping Metadata

Go Up to Working with Data Definition Statements

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.

Topics

• Dropping an Index
• Dropping a View
• Dropping a Table

Advance To:

• Dropping an Index