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