SQL ServerTransact-SQL에는 다음과 같은 DROP 문이 있습니다. DROP 문을 사용하여 기존 엔터티를 제거할 수 있습니다. 예를 들어 DROP TABLE을 사용하여 데이터베이스에서 테이블을 제거할 수 있습니다.
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