Results of 1 - 10 of about 13 for Constraint (0.003 sec.)
- Information Schema – DuckDB 12492
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...value. No fractional seconds are currently supported in DuckDB. For all other data types, this column is NULL . INTEGER 0 constraint_column_usage : Constraint Column Usage This view describes all columns in the current database that are used by some const...raint. For a check constraint, this view identifies the columns that are used in the check expression. For a not-null constraint, this view identifies t... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Constraints – DuckDB 11877
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...Internals Overview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL Copy Markdown Constraints In SQL, constraints can be specified for tables. Constraints enforce certain properties over data that is inserted into a...table. Constraints can be specified along with the schema of the table as part of the CREATE TABLE statement . In certain cases, constraints... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- Indexes – DuckDB 9959
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...l general-purpose data types . Adaptive Radix Tree (ART) An Adaptive Radix Tree (ART) is mainly used to ensure primary key constraints and to speed up point and very highly selective (i.e., < 0.1%) queries. ART indexes can be created manually using CREATE...INDEX clause and they are automatically created for columns with a UNIQUE or PRIMARY KEY constraint. Warning ART indexes must currently be able to fit in memory during index creation. Avoid creating ART indexes if the inde... - https://man.mtool.work/duckdb/1.3/sql/indexes.html
- CREATE TABLE Statement – DuckDB 9783
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...y key: CREATE TABLE t1 ( id INTEGER , j VARCHAR , PRIMARY KEY ( id , j )); Create a table with various different types and constraints: CREATE TABLE t1 ( i INTEGER NOT NULL , decimalnr DOUBLE CHECK ( decimalnr < 10 ), date DATE UNIQUE , time TIMESTAMP ); C...t1 AS FROM t2 LIMIT 0 ; Note that only the column names and types are copied to t2 , other pieces of information (indexes, constraints, default values, etc.) are not copied. Temporary Tables Temporary tables can be created using the CREATE TEMP TABLE or th... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- DuckDB_% Metadata Functions – DuckDB 9624
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...uckDB internal objects. (In fact, information_schema.columns is implemented as a query on top of duckdb_columns() ) duckdb_constraints The duckdb_constraints() function provides metadata about the constraints available in the DuckDB instance. Column Descri...ption Type database_name The name of the database that contains the constraint. VARCHAR database_oid Internal identifier of the database that contains the constraint. BIGINT schema_name The SQL name of... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- INSERT Statement – DuckDB 8551
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...default value into a column: INSERT INTO tbl ( i ) VALUES ( 1 ), ( DEFAULT ), ( 3 ); Assuming tbl has a primary key/unique constraint, do nothing on conflict: INSERT OR IGNORE INTO tbl ( i ) VALUES ( 1 ); Or update the table with the new values instead: IN...CT Clause An ON CONFLICT clause can be used to perform a certain action on conflicts that arise from UNIQUE or PRIMARY KEY constraints. An example for such a conflict is shown in the following example: CREATE TABLE tbl ( i INTEGER PRIMARY KEY , j INTEGER )... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- ALTER TABLE Statement – DuckDB 8005
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...COLUMN i DROP DEFAULT ; Make a column not nullable: ALTER TABLE integers 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 TO integers_old ; Rename...OLUMN i TO j ; ALTER TABLE integers RENAME i TO j ; The RENAME [COLUMN] clause renames a single column within a table. Any constraints that rely on this name (e.g., CHECK constraints) are automatically updated. However, note that any views that rely on thi... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_table.html
- Appender – DuckDB 7970
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...ly using transactions and surrounding your batches of AppendRow calls by BEGIN TRANSACTION and COMMIT statements. Handling Constraint Violations If the Appender encounters a PRIMARY KEY conflict or a UNIQUE constraint violation, it fails and returns the fo...llowing error: Constraint Error: PRIMARY KEY or UNIQUE constraint violated: duplicate key "..." In this case, the entire append operation fails and... - https://man.mtool.work/duckdb/1.3/data/appender.html
- Appender – DuckDB 7354
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...er_flush Flush the appender to the table, forcing the cache of the appender to be cleared. If flushing the data triggers a constraint violation or any other error, then all data is invalidated, and this function returns DuckDBError. It is not possible to a...loses the appender by flushing all intermediate states and closing it for further appends. If flushing the data triggers a constraint violation or any other error, then all data is invalidated, and this function returns DuckDBError. Call duckdb_appender_er... - https://man.mtool.work/duckdb/1.3/clients/c/appender.html
- Text Types – DuckDB 7178
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords a...ied for strings. If you wish to restrict the number of characters in a VARCHAR column for data integrity reasons the CHECK constraint should be used, for example: CREATE TABLE strings ( val VARCHAR CHECK ( length ( val ) <= 10 ) -- val has a maximum length... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
DuckDB 1.3 Documentation / man.mtool.work