TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

DROP Statements (Transact-SQL)

 

Updated: May 2, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Transact-SQL contains the following DROP statements. Use DROP statements to remove existing entities. For example, use DROP TABLE to remove a table from a database.

DROP AGGREGATEDROP EXTERNAL FILE FORMATDROP SCHEMA
DROP APPLICATION ROLEDROP EXTERNAL RESOURCE POOLDROP SEARCH PROPERTY LIST
DROP ASSEMBLYDROP EXTERNAL TABLEDROP SECURITY POLICY
DROP ASYMMETRIC KEYDROP FULLTEXT CATALOGDROP SEQUENCE
DROP AVAILABILITY GROUPDROP FULLTEXT INDEXDROP SERVER AUDIT
DROP BROKER PRIORITYDROP FULLTEXT STOPLISTDROP SERVER AUDIT SPECIFICATION
DROP CERTIFICATEDROP FUNCTIONDROP SERVER ROLE
DROP COLUMN ENCRYPTION KEYDROP INDEXDROP SERVICE
DROP COLUMN MASTER KEY DEFINITIONDROP INDEX (XML Selective Indexes)DROP SIGNATURE
DROP CONTRACTDROP LOGINDROP STATISTICS
DROP CREDENTIALDROP MASTER KEYDROP SYMMETRIC KEY
DROP CRYPTOGRAPHIC PROVIDERDROP MESSAGE TYPEDROP SYNONYM
DROP DATABASEDROP PARTITION FUNCTIONDROP TABLE
DROP DATABASE AUDIT SPECIFICATIONDROP PARTITION SCHEMEDROP TRIGGER
DROP DATABASE ENCRYPTION KEYDROP PROCEDUREDROP TYPE
DROP DATABASE SCOPED CREDENTIALDROP QUEUEDROP USER
DROP DEFAULTDROP REMOTE SERVICE BINDINGDROP VIEW
DROP ENDPOINTDROP RESOURCE POOLDROP WORKLOAD GROUP
DROP EVENT NOTIFICATIONDROP ROLEDROP XML SCHEMA COLLECTION
DROP EVENT SESSIONDROP ROUTE
DROP EXTERNAL DATA SOURCEDROP RULE

ALTER Statements (Transact-SQL)
CREATE Statements (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft