Eksporter (0) Skriv ut
Vis alt
Dette innholdet er ikke tilgjengelig på ditt språk, men her er den engelske versjonen.

DROP TABLE (Azure SQL Database)

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

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.

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.


Legg til
© 2014 Microsoft