Results of 1 - 10 of about 43 for Drop (0.001 sec.)
- DROP Statement 14099
- 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 : DR...OP SEQUENCE seq; Drop macro mcr : DROP MACRO mcr; Drop macro table mt : DROP MACRO TABLE mt; -- the `TABLE` is optional since v1.4.0 Drop type t...yp : DROP TYPE typ; Syntax Dependencies of Dropped Objects DuckDB performs limited dependency tracking for some object types. By def... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- ALTER TABLE Statement 12726
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...to the table integers, it will be filled with the default value 10: ALTER TABLE integers ADD COLUMN l INTEGER DEFAULT 10; Drop the column k from the table integers: ALTER TABLE integers DROP k; Change the type of the column i to the type VARCHAR usi...PE VARCHAR USING concat(i, '_', j); Set the default value of a column: ALTER TABLE integers ALTER COLUMN i SET DEFAULT 10; Drop the default value of a column: ALTER TABLE integers ALTER COLUMN i DROP DEFAULT; Make a column not nullable: ALTER TABLE i...ntegers ALTER COLUMN i SET NOT NULL; Drop the not- NULL constraint: ALTER TABLE integers ALTER COLUMN i DROP NOT NULL; Rename a table: ALTER TABLE integers RENAME T... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- CREATE SEQUENCE Statement 10566
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...E allows cycling through the same sequence repeatedly: CREATE SEQUENCE serial START WITH 1 MAXVALUE 10 CYCLE; Creating and Dropping Sequences Sequences can be created and dropped similarly to other catalog items. Overwrite an existing sequence: CREAT...QUENCE serial; Only create sequence if no such sequence exists yet: CREATE SEQUENCE IF NOT EXISTS serial; Remove sequence: DROP SEQUENCE serial; Remove sequence if exists: DROP SEQUENCE IF EXISTS serial; Using Sequences for Primary Keys Sequences can...escending ones. TEMPORARY or TEMP If specified, the sequence object is created only for this session, and is automatically dropped on session exit. Existing permanent sequences with the same name are not visible (in this session) while the temporary... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- TPC-H Extension 10474
- The tpch extension implements the data generator and queries for the TPC-H benchmark . Installing and Loading The tpch extension is shipped by default in some DuckDB builds, otherwise it will be transparently autoloaded on first use. If you
...factor 1, use: CALL dbgen(sf = 1); Calling dbgen does not clean up existing TPC-H tables. To clean up existing tables, use DROP TABLE before running dbgen : DROP TABLE IF EXISTS customer; DROP TABLE IF EXISTS lineitem; DROP TABLE IF EXISTS nation; DR...OP TABLE IF EXISTS orders; DROP TABLE IF EXISTS part; DROP TABLE IF EXISTS partsupp; DROP TABLE IF EXISTS region; DROP TABLE IF EXISTS supplier; Running a... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- CREATE TRIGGER Statement 9008
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...: CREATE TRIGGER trg_price AFTER UPDATE OF price ON products FOR EACH STATEMENT INSERT INTO price_changes DEFAULT VALUES; Drop a trigger: DROP TRIGGER trg_audit ON target; Drop a trigger if it exists: DROP TRIGGER IF EXISTS trg_audit ON target; Synt...triggers() function : SELECT trigger_name, table_name, action_timing, event_manipulation, for_each FROM duckdb_triggers(); Dropping Triggers A trigger is dropped with DROP TRIGGER . The table the trigger is attached to must be specified: For example:...DROP TRIGGER trg_audit ON target; Dropping a trigger that does not exist results in an error. Use IF EXISTS to skip the stateme... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- Import Data 8684
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...for a row that later fails a constraint check. Always call flush() explicitly and check its result before the appender is dropped. Dropping an appender flushes any remaining rows, but errors raised during that implicit flush are discarded, because R...ust's Drop cannot report them. The Appender is Sync but not Send , because it borrows the Connection . To append from another thread,...saction lets DuckDB commit them as a single unit. Begin a transaction with Connection::transaction() , set it to commit on drop, and create the appender from the transaction. The following bulk-inserts ten million rows, adapted from the crate's appen... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- Writing to Iceberg 8684
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...upported Operations The iceberg extension supports the following operations when used with a REST Catalog attached: CREATE/DROP SCHEMA CREATE/DROP TABLE INSERT INTO UPDATE DELETE MERGE INTO ALTER TABLE SELECT Since these operations are supported, the...ceberg and DuckDB storage. Creating Schemas and Tables Iceberg namespaces are exposed as schemas, which can be created and dropped with CREATE SCHEMA and DROP SCHEMA : CREATE SCHEMA iceberg_catalog.sales; USE iceberg_catalog.sales; Tables are created...DD COLUMN col3 DOUBLE; -- Rename a column ALTER TABLE iceberg_catalog.default.renamed_table RENAME COLUMN col2 TO name; -- Drop a column ALTER TABLE iceberg_catalog.default.renamed_table DROP COLUMN col3; -- Change the type of a column ALTER TABLE ic... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Join Operations 8098
- How to Force a Join Order DuckDB has a cost-based query optimizer, which uses statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn
...REPLACE TEMPORARY TABLE t2 AS SELECT * FROM t1 ...; -- compute the final result using t2 SELECT * FROM t1 ... To clean up, drop the interim tables: DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; Configuring the Join Order Optimizer DuckDB's join o... - https://man.mtool.work/duckdb/2.0/guides/performance/join_operations.html
- Indexes 8052
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...dexing via the spatial extension. Persistence Both min-max indexes and ART indexes are persisted on disk. CREATE INDEX and DROP INDEX Statements To create an ART index , use the CREATE INDEX statement . To drop an ART index , use the DROP INDEX state...00); BEGIN; CREATE TEMP TABLE tmp AS SELECT i FROM my_table; DELETE FROM my_table; INSERT INTO my_table SELECT i FROM tmp; DROP TABLE tmp; COMMIT; In other clients, you might be able to fetch the result of DELETE ... RETURNING ... . Then, you can use... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- CREATE INDEX Statement 8052
- CREATE INDEX The CREATE INDEX statement constructs an index on the specified column(s) of the specified table. Examples Create a unique index films_id_idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films (id); Cre
...x option in the form of a Boolean true value (e.g., is_cool ) or a key-value pair (e.g., my_option = 2 ). Optional. Syntax DROP INDEX DROP INDEX drops an existing index from the database system. Examples Remove the index title_idx : DROP INDEX title_... - https://man.mtool.work/duckdb/2.0/sql/statements/create_index.html
DuckDB 2.0 Documentation / man.mtool.work