Export (0) Print
Expand All

DROP TABLE (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see DROP TABLE.

Removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for the dropped tables. Any view or stored procedure that references the dropped table must be explicitly dropped by using DROP VIEW or DROP PROCEDURE.

Syntax Conventions (Azure SQL Database)


DROP TABLE [ database_name . [ schema_name ] . | schema_name . ]
        table_name [ ,...n ] [ ; ]

This syntax diagram demonstrates the supported arguments and options in Microsoft Microsoft Azure SQL Database.

noteNote
Microsoft Azure SQL Database supports the three-part name format database_name.[schema_name].object_name when the database_name is the current database or the database_name is tempdb and the object_name starts with #.

Microsoft Azure SQL Database does not support four-part names.

For more information about the arguments and the DROP TABLE statement, see DROP TABLE in SQL Server Books Online.

Community Additions

ADD
Show:
© 2014 Microsoft