Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 Windows Azure SQL Database.

noteNote
Windows 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 #.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.