DROP Statements (Transact-SQL)

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.

In This Section

DROP AGGREGATE DROP EXTERNAL FILE FORMAT DROP SCHEMA
DROP APPLICATION ROLE DROP EXTERNAL RESOURCE POOL DROP SEARCH PROPERTY LIST
DROP ASSEMBLY DROP EXTERNAL TABLE DROP SECURITY POLICY
DROP ASYMMETRIC KEY DROP FULLTEXT CATALOG DROP SEQUENCE
DROP AVAILABILITY GROUP DROP FULLTEXT INDEX DROP SERVER AUDIT
DROP BROKER PRIORITY DROP FULLTEXT STOPLIST DROP SERVER AUDIT SPECIFICATION
DROP CERTIFICATE DROP FUNCTION DROP SERVER ROLE
DROP COLUMN ENCRYPTION KEY DROP INDEX DROP SERVICE
DROP COLUMN MASTER KEY DEFINITION DROP INDEX (XML Selective Indexes) DROP SIGNATURE
DROP CONTRACT DROP LOGIN DROP STATISTICS
DROP CREDENTIAL DROP MASTER KEY DROP SYMMETRIC KEY
DROP CRYPTOGRAPHIC PROVIDER DROP MESSAGE TYPE DROP SYNONYM
DROP DATABASE DROP PARTITION FUNCTION DROP TABLE
DROP DATABASE AUDIT SPECIFICATION DROP PARTITION SCHEME DROP TRIGGER
DROP DATABASE ENCRYPTION KEY DROP PROCEDURE DROP TYPE
DROP DATABASE SCOPED CREDENTIAL DROP QUEUE DROP USER
DROP DEFAULT DROP REMOTE SERVICE BINDING DROP VIEW
DROP ENDPOINT DROP RESOURCE POOL DROP WORKLOAD GROUP
DROP EVENT NOTIFICATION DROP ROLE DROP XML SCHEMA COLLECTION
DROP EVENT SESSION DROP ROUTE
DROP EXTERNAL DATA SOURCE DROP RULE

See Also

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