Search Result: sch - DuckDB 2.0 全文検索

DROP Statement 9414: The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI ... EW IF EXISTS view1; Drop function fn : DROP FUNCTION fn; Drop index idx : DROP INDEX idx; Drop schema sch : DROP SCHEMA sch; Drop sequence seq : DROP SEQUENCE seq; Drop macro mcr : DROP MACRO mcr; Drop macro table mt : DR ... t. If the CASCADE clause is provided then all the objects that are dependent on the object will be dropped as well. CREATE SCHEMA myschema; CREATE TABLE myschema.t1 (i INTEGER); DROP SCHEMA myschema; Dependency Error: Cannot drop entry "myschema" be ... cause there are entries that depend on it. table "t1" depends on schema "myschema". Use DROP...CASCADE to drop all dependents. The CASCADE modifier drops both myschema and myschema.t1 : CREAT ...; https://man.mtool.work/duckdb/2.0/sql/statements/drop.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work