Results of 1 - 10 of about 19 for referenced (0.003 sec.)
- CREATE TABLE Statement – DuckDB 15111
- 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
...SERT INTO t2 VALUES ( 2 , 2 ); Constraint Error: Violates foreign key constraint because key "id: 2" does not exist in the referenced table Foreign keys can be defined on composite primary keys: CREATE TABLE t3 ( id INTEGER , j VARCHAR , PRIMARY KEY ( id ,...VALUES ( 2 , 1 , 'b' ); Constraint Error: Violates foreign key constraint because key "id: 1, j: b" does not exist in the referenced table Foreign keys can also be defined on unique columns: CREATE TABLE t5 ( id INTEGER UNIQUE , j VARCHAR ); CREATE TABLE...l result in the following error: Constraint Error: Violates foreign key constraint because key "..." does not exist in the referenced table. Generated Columns The [type] [GENERATED ALWAYS] AS (expr) [VIRTUAL|STORED] syntax will create a generated column. T... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- DuckDB_% Metadata Functions – DuckDB 10586
- 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
...ay of table column names appearing in the constraint definition. VARCHAR[] constraint_name The naem of constraint. VARCHAR referenced_table The table referenced by the constraint. VARCHAR referenced_column_names The column names references the by the const...t a value of this type in memory. BIGINT logical_type The 'canonical' name of this data type. The same logical_type may be referenced by several types having different type_name s. VARCHAR type_category The category to which this type belongs. Data types w... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Configuration – DuckDB 8776
- 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
...enable_logging Enables the logger BOOLEAN 0 enable_macro_dependencies Enable created MACROs to create dependencies on the referenced objects (such as tables) BOOLEAN false enable_object_cache [PLACEHOLDER] Legacy setting - does nothing BOOLEAN NULL enable...r side certificate verification. BOOLEAN false enable_view_dependencies Enable created VIEWs to create dependencies on the referenced objects (such as tables) BOOLEAN false enabled_log_types Sets the list of enabled loggers VARCHAR extension_directory Set... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- CREATE VIEW Statement – DuckDB 8776
- 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
...VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced in a query. CREATE OR REPLACE VIEW is similar, but if a view of the same name already exists, it is replaced. If a schema... - https://man.mtool.work/duckdb/1.3/sql/statements/create_view.html
- Order Preservation – DuckDB 8486
- 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
...orementioned components Tip row_number() OVER () allows turning the original row order into an explicit column that can be referenced in the operations that don't preserve row order by default. On materialized tables, the rowid pseudo-column can be used to... - https://man.mtool.work/duckdb/1.3/sql/dialect/order_preservation.html
- Python API – DuckDB 8179
- 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
...he query. The query is not executed until the result is fetched or requested to be printed to the screen. Relations can be referenced in subsequent queries by storing them inside variables, and using them as tables. This way queries can be constructed incr... - https://man.mtool.work/duckdb/1.3/clients/python/overview.html
- Jupyter Notebooks – DuckDB 8179
- 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
...the use of the --save , and --no-execute functions. This tells JupySQL to store the query, but skips execution. It will be referenced in the next plotting call. %% sql --save short_trips --no-execute SELECT * FROM 'https://d37ci6vzurychx.cloudfront.net/tri... - https://man.mtool.work/duckdb/1.3/guides/python/jupyter.html
- Constraints – DuckDB 8179
- 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
...ams VALUES ( 2 , 1 , 2 , 10 ); Constraint Error: Violates foreign key constraint because key "id: 2" does not exist in the referenced table In order to enforce this property efficiently, an ART index is automatically created for every foreign key constrain... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- Indexes – DuckDB 8179
- 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
...le SET payload = [ 'world' ] WHERE id = 1 ; Constraint Error: Violates foreign key constraint because key "id: 1" is still referenced by a foreign key in a different table. If this is an unexpected constraint violation, please refer to our foreign key limi... - https://man.mtool.work/duckdb/1.3/sql/indexes.html
- CREATE SEQUENCE Statement – DuckDB 8179
- 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
...manent sequences with the same name are not visible (in this session) while the temporary sequence exists, unless they are referenced with schema-qualified names. Sequences are based on BIGINT arithmetic, so the range cannot exceed the range of an eight-by... - https://man.mtool.work/duckdb/1.3/sql/statements/create_sequence.html
DuckDB 1.3 Documentation / man.mtool.work