Results of 1 - 7 of about 7 for Rename (0.005 sec.)
- ALTER TABLE Statement – DuckDB 13304
- 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
...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 a column of a table: ALTER TABLE integers RENAME i TO ii ; A...ntics, i.e., they will not be visible to other transactions until committed, and can be fully reverted through a rollback. RENAME TABLE Rename a table: ALTER TABLE integers RENAME TO integers_old ; The RENAME TO clause renames an entire table, changing...its name in the schema. Note that any views that rely on the table are not automatically updated. RENAME COLUMN To rename a column of a table, use the RENAME or RENAME COLUMN clauses: ALTER TABLE integers RENAME COLUMN i TO j ;... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_table.html
- Star Expression – DuckDB 9469
- 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
...e specific columns by alternative expressions. SELECT * REPLACE ( col1 / 1_000 AS col1 , col2 / 1_000 AS col2 ) FROM tbl ; RENAME Clause RENAME allows you to replace specific columns. SELECT * RENAME ( col1 AS height , col2 AS width ) FROM tbl ; Column...lumns with Regular Expressions in a COLUMNS Expression The matches of capture groups in regular expressions can be used to rename matching columns. The capture groups are one-indexed; \0 is the original column name. For example, to select the first thr...that match the lambda function will be returned. This allows the execution of arbitrary expressions in order to select and rename columns. SELECT COLUMNS ( c -> c LIKE '%num%' ) FROM numbers ; number 10 20 NULL COLUMNS List COLUMNS also supports passin... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- ALTER VIEW Statement – DuckDB 8960
- 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
...opy Markdown ALTER VIEW Statement The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW v1 RENAME TO v2 ; ALTER VIEW changes the schema of an existing table. All the changes made by ALTER VIE...ワード changes schema existing view table fully Documentation Statements Copy Markdown Statement statement catalog Examples Rename made respect transactional semantics they visible transactions until committed reverted 関連するページ CREATE VIEW Stateme... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_view.html
- VALUES Clause – DuckDB 8106
- 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
...ws and directly return them: VALUES ( 'Amsterdam' , 1 ), ( 'London' , 2 ); Generate two rows as part of a FROM clause, and rename the columns: SELECT * FROM ( VALUES ( 'Amsterdam' , 1 ), ( 'London' , 2 )) cities ( name , id ); Generate two rows and ins... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/values.html
- Python Client API – DuckDB 7924
- 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
...Relational API page . set_alias ( self : duckdb.duckdb.DuckDBPyRelation , alias : str ) → duckdb.duckdb.DuckDBPyRelation ¶ Rename the relation object to new alias Detailed examples can be found at Relational API page . shape ¶ Tuple of # of rows, # of...: pandas.DataFrame , alias : str , * , connection : duckdb.DuckDBPyConnection = None ) → duckdb.duckdb.DuckDBPyRelation ¶ Rename the relation object to new alias duckdb. append ( table_name : str , df : pandas.DataFrame , * , by_name : bool = False ,... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Struct Data Type – DuckDB 7924
- 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
...L} │ └──────────────────────────────┘ Renaming a Field Renaming field j of struct s to v1 in table test`: ALTER TABLE test RENAME s.j TO v1 ; FROM test ; ┌───────────────────────────────┐ │ s │ │ struct(v1 integer, k integer) │ ├───────────────────────... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- Relational API – DuckDB 7870
- 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
...ery Run the given SQL query in sql_query on the view named virtual_table_name that refers to the relation object set_alias Rename the relation object to new alias shape Tuple of # of rows, # of columns in relation. show Display a summary of the data sq...re set_alias ( self : duckdb . duckdb . DuckDBPyRelation , alias : str ) -> duckdb . duckdb . DuckDBPyRelation Description Rename the relation object to new alias Parameters alias : str The alias name to assign to the relation. Example import duckdb du... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work