Results of 1 - 10 of about 15 for Keywords (0.002 sec.)
- DuckDB Environment 12644
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...etween objects duckdb_extensions() : extensions duckdb_functions() : functions duckdb_indexes() : secondary indexes duckdb_keywords() : DuckDB's keywords and reserved words duckdb_optimizers() : the available optimization rules in the DuckDB instance duc... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- Keywords and Identifiers 11477
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keywords
...database that has one of these names, use an alias, e.g.: ATTACH 'temp.db' AS temp2; USE temp2; Rules for Case-Sensitivity Keywords and Function Names SQL keywords and function names are case-insensitive in DuckDB. For example, the following two queries... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Autocomplete 10292
- The shell offers context-aware autocomplete of SQL queries through the autocomplete extension . autocomplete is triggered by pressing Tab . Multiple autocomplete suggestions can be present. You can cycle forwards through the suggestions by
...b to cycle backwards. autocompletion can be reverted by pressing ESC twice. The shell autocompletes four different groups: Keywords Table names and table functions Column names and scalar functions File names The shell looks at the position in the SQL st... - https://man.mtool.work/duckdb/2.0/clients/cli/autocomplete.html
- ALTER DATABASE Statement 10292
- Warning The ALTER DATABASE statement is not supported in DuckDB 2.0.0: ALTER DATABASE ⟨old_name⟩ RENAME TO ⟨new_name⟩ fails with Parser Error: syntax error at or near "RENAME" . To rename an attached database, DETACH it and ATTACH it again
...scenarios are not supported when renaming a DuckDB database with ALTER DATABASE : Renaming a database to certain reserved keywords such as system or temp . Renaming a database to the same name of a database attached in memory. Rename a database from old... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_database.html
- DuckDB_% Metadata Functions 9718
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...IQUE constraints are maintained using indexes, but their details are included in the duckdb_constraints() function. duckdb_keywords The duckdb_keywords() function provides metadata about DuckDB's keywords and reserved words. Column Description Type keywo...me but not as a type or function name), or type_function (usable as a type or function name but not as a column name). See Keywords and Identifiers . VARCHAR duckdb_log_contexts The duckdb_log_contexts() function provides information on the contexts of D... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Syntax Highlighting 9125
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
...using the .highlight off command. Below is a list of query components that can be configured. Type Component Default color Keywords keyword green Numeric constants numeric_constant yellow String constants string_constant yellow Comments comment gray Erro... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- Benchmark Suite 7959
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...can ensure that the header has the expected structure and prevent tidy check errors. Below this header, there are a set of keywords summarizing the benchmark. name FillPerformance group micro subgroup window While some benchmarks run a single query, it c... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Utility Functions 7959
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...mat_sql(sql[, config]) Formats the sql string, e.g., by placing each clause on a separate line and normalizing the case of keywords. The optional config is a MAP(VARCHAR, VARCHAR) with the keys 'indent_size' , 'inline_threshold' and 'keyword_case' ( 'upp...nfig]) | Description | Formats the sql string, e.g., by placing each clause on a separate line and normalizing the case of keywords. The optional config is a MAP(VARCHAR, VARCHAR) with the keys 'indent_size' , 'inline_threshold' and 'keyword_case' ( 'upp... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Interval Type 7663
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...ported; stored as (48 * 60 * 60 * 1e6 microseconds) ; Warning Decimal values are truncated to integers when used with unit keywords (unless the unit is SECONDS or MILLISECONDS ). sql SELECT INTERVAL '1.5' YEARS; -- Returns 12 months; equivalent to `to_ye... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Star Expression 7663
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...w As of DuckDB 2.0, EXCEPT is accepted as a synonym for EXCLUDE , matching the SQL-standard and BigQuery spelling. The two keywords are interchangeable and may be mixed in the same query. sql SELECT * EXCEPT (col) FROM tbl; REPLACE Clause REPLACE allows... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
DuckDB 2.0 Documentation / man.mtool.work