CTAS (CREATE TABLE AS SELECT)
GPTKB entity
Statements (14)
Predicate | Object |
---|---|
gptkbp:instanceOf |
SQL statement
|
gptkbp:abbreviation |
CREATE TABLE AS SELECT
|
gptkbp:category |
gptkb:Data_Definition_Language
gptkb:Data_Manipulation_Language |
gptkbp:hasSyntax |
CREATE TABLE new_table AS SELECT * FROM existing_table;
|
https://www.w3.org/2000/01/rdf-schema#label |
CTAS (CREATE TABLE AS SELECT)
|
gptkbp:purpose |
create new table from query result
|
gptkbp:usedIn |
gptkb:MySQL
gptkb:Oracle_Database gptkb:Microsoft_SQL_Server gptkb:PostgreSQL SQL |
gptkbp:bfsParent |
gptkb:Amazon_Redshift_SQL
|
gptkbp:bfsLayer |
7
|