DuckDB Semantic Views

DROP SEMANTIC VIEW¶

Removes a semantic view definition from the catalog.

Syntax¶

DROP SEMANTIC VIEW [ IF EXISTS ] <name>

Statement Variants¶

DROP SEMANTIC VIEW <name>: Drops the named semantic view. Returns an error if the view does not exist.
DROP SEMANTIC VIEW IF EXISTS <name>: Drops the named semantic view if it exists. If the view does not exist, the statement succeeds silently.

Parameters¶

<name>: The name of the semantic view to drop. Case-sensitive.

Examples¶

-- Drop an existing view
DROP SEMANTIC VIEW order_metrics;

-- Drop only if it exists (no error if missing)
DROP SEMANTIC VIEW IF EXISTS order_metrics;