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
|