Results of 1 - 10 of about 16 for Dropping (0.001 sec.)
- ALTER TABLE Statement 12372
- 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
...T clause modifies the DEFAULT value of an existing column. Note that this does not modify any existing data in the column. Dropping the default is equivalent to setting the default value to NULL. Warning At the moment, DuckDB does not allow most ALTER TA...BLE operations (e.g., renaming the table, renaming, dropping or changing the type of columns, or setting or dropping NOT NULL ) on a table that has an index. Adding columns and settin...g or dropping column defaults are allowed. For other changes, drop the index, alter the table, and then recreate the index. Otherwise, y... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- CREATE TRIGGER Statement 12112
- 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
...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: DRO...P TRIGGER trg_audit ON target; Dropping a trigger that does not exist results in an error. Use IF EXISTS to skip the statement if the trigger does not exist: DROP...st exist even when IF EXISTS is specified. The table name can be qualified with a schema name, e.g., ON my_schema.target . Dropping a table also drops all triggers defined on it. Limitations DuckDB 2.0 has the following limitations: BEFORE ... FOR EACH R... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- CREATE SEQUENCE Statement 11610
- 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: CREATE OR...depends on sequence "id_sequence". Use DROP...CASCADE to drop all dependents. As the error message suggests, you can force dropping by adding CASCADE . However, DuckDB currently tracks dependencies at the table level, so attempting to drop with CASCADE d...sequence". Use DROP...CASCADE to drop all dependents. To replace the sequence, first remove the dependency, for example by dropping the column default: ALTER TABLE tbl ALTER COLUMN id DROP DEFAULT; CREATE OR REPLACE SEQUENCE id_sequence;... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- Extension Repositories 9010
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...sion_repositories() table function: SELECT repository_name, prefix, key_fingerprints FROM duckdb_extension_repositories(); Dropping a Repository DROP EXTENSION REPOSITORY my_repo;... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- DROP Statement 9010
- 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
...PRAGMA and check the number of free_blocks in the output: PRAGMA database_size; For instructions on reclaiming space after dropping a table, refer to the “Reclaiming space” page .... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- Prepared Statements 8491
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...rameters are matched by position and are never filled from a session variable, even one whose name is a number such as 1 . Dropping Prepared Statements: DEALLOCATE To drop a prepared statement, use the DEALLOCATE statement: DEALLOCATE query_person; Alter... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- Import Data 8231
- 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
...w 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 Rust's Drop ca... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- AsOf Join 7971
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...ker = p.ticker AND h.when >= p.when ORDER BY ALL; As you might expect, this will produce NULL prices and values instead of dropping left side rows when there is no ticker or the time is before the prices begin. ticker when value APPL 2000-12-31 23:59:30... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
- Enum Data Type 7971
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...removal feature is subject to change. In future releases, it is expected that any dependent columns must be removed before dropping the enum, or the enum must be dropped with the additional CASCADE parameter.... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- R-Tree Indexes 7711
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...f you find that the performance of querying the R-tree starts to deteriorate after a large number of updates or deletions, dropping and re-creating the index might produce a higher quality R-tree. Memory Usage Like DuckDB's built in ART-index, all the as... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
DuckDB 2.0 Documentation / man.mtool.work