DROP <object>¶

Removes the specified object from the system.

See also:

CREATE <object> , SHOW <objects> , UNDROP <object>

DROP commands¶

For specific syntax, usage notes, and examples, see:

Organization Objects:

• DROP ACCOUNT

Account Objects:

• DROP APPLICATION
• DROP APPLICATION PACKAGE
• DROP AUTHENTICATION POLICY
• DROP CATALOG INTEGRATION
• DROP COMPUTE POOL
• DROP CONNECTION
• DROP DATABASE
• DROP DATABASE ROLE
• DROP EXTERNAL VOLUME
• DROP FAILOVER GROUP
• DROP FEATURE POLICY
• DROP INTEGRATION
• DROP NETWORK POLICY
• DROP ORGANIZATION PROFILE
• DROP POSTGRES INSTANCE
• DROP REPLICATION GROUP
• DROP RESOURCE MONITOR
• DROP ROLE
• DROP SHARE
• DROP USER
• DROP WAREHOUSE

Database Objects:

• DROP AGENT
• DROP AGGREGATION POLICY
• DROP ALERT
• DROP AUTHENTICATION POLICY
• DROP BACKUP POLICY
• DROP BACKUP SET
• DROP CONTACT
• DROP CORTEX SEARCH SERVICE
• DROP DBT PROJECT
• DROP DCM PROJECT
• DROP DYNAMIC TABLE
• DROP EXPERIMENT
• DROP EXTERNAL AGENT
• DROP EXTERNAL TABLE
• DROP FILE FORMAT
• DROP FUNCTION
• DROP GATEWAY
• DROP GIT REPOSITORY
• DROP ICEBERG TABLE
• DROP IMAGE REPOSITORY
• DROP INDEX
• DROP JOIN POLICY
• DROP LISTING
• DROP MAINTENANCE POLICY
• DROP MASKING POLICY
• DROP MATERIALIZED VIEW
• DROP MCP SERVER
• DROP MODEL
• DROP MODEL MONITOR
• DROP NETWORK RULE
• DROP NOTEBOOK
• DROP ONLINE FEATURE TABLE
• DROP PACKAGES POLICY
• DROP PASSWORD POLICY
• DROP PIPE
• DROP PRIVACY POLICY
• DROP PROCEDURE
• DROP PROJECTION POLICY
• DROP ROW ACCESS POLICY
• DROP SCHEMA
• DROP SECRET
• DROP SEMANTIC VIEW
• DROP SEQUENCE
• DROP SERVICE
• DROP SESSION POLICY
• DROP SNAPSHOT
• DROP SNAPSHOT POLICY — Deprecated (deprecated; prefer DROP BACKUP POLICY)
• DROP SNAPSHOT SET — Deprecated (deprecated; prefer DROP BACKUP SET)
• DROP STAGE
• DROP STORAGE LIFECYCLE POLICY
• DROP STREAM
• DROP STREAMLIT
• DROP TABLE
• DROP TAG
• DROP TASK
• DROP TYPE
• DROP VIEW

Classes:

• DROP BUDGET
• DROP CLASSIFICATION_PROFILE
• DROP CUSTOM_CLASSIFIER