DROP Statements (Transact-SQL)

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 FULLTEXT CATALOG	DROP RULE
DROP APPLICATION ROLE	DROP FULLTEXT INDEX	DROP SCHEMA
DROP ASSEMBLY	DROP FULLTEXT STOPLIST	DROP SERVER AUDIT
DROP ASYMMETRIC KEY	DROP FUNCTION	DROP SERVER AUDIT SPECIFICATION
DROP BROKER PRIORITY	DROP INDEX	DROP SERVICE
DROP CERTIFICATE	DROP LOGIN	DROP SIGNATURE
DROP CONTRACT	DROP MASTER KEY	DROP STATISTICS
DROP CREDENTIAL	DROP MESSAGE TYPE	DROP SYMMETRIC KEY
DROP CRYPTOGRAPHIC PROVIDER	DROP PARTITION FUNCTION	DROP SYNONYM
DROP DATABASE	DROP PARTITION SCHEME	DROP TABLE
DROP DATABASE AUDIT SPECIFICATION	DROP PROCEDURE	DROP TRIGGER
DROP DATABASE ENCRYPTION KEY	DROP QUEUE	DROP TYPE
DROP DEFAULT	DROP REMOTE SERVICE BINDING	DROP USER
DROP ENDPOINT	DROP RESOURCE POOL	DROP VIEW
DROP EVENT NOTIFICATION	DROP ROLE	DROP WORKLOAD GROUP
DROP EVENT SESSION	DROP ROUTE	DROP XML SCHEMA COLLECTION

See Also

Other Resources

ALTER Statements (Transact-SQL)

CREATE Statements (Transact-SQL)