Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

DROP TABLE (SQL Server Compact Edition)

Removes a table definition and all data, indexes, constraints, and permission specifications for that table.

DROP TABLE < table_name >


Specifies the name of the table to be removed.

DROP TABLE cannot be used to drop a table referenced by a FOREIGN KEY constraint. The referencing FOREIGN KEY constraint or the referencing table must be dropped first.

When a table is dropped, rules or defaults on it lose their binding, and any constraints associated with it are automatically dropped. If you re-create a table, you must rebind the appropriate rules and defaults, and add all necessary constraints.

You cannot use the DROP TABLE statement on system tables.

© 2016 Microsoft