`CREATE TABLE AS Select` (CTAS) and its associated syntax creates a new table by performing the following - Run a CREATE TABLE using the table definition of every column in the SELECT - Populating the new table with the result set of the SELECT NOTE : The table created has no indexes or constraints.

Create Table As Select (CTAS) is a method to create a table with a query. It's supported by multiple vendors including Windows Azure DB Warehouse, Oracle, and PostgreSQL. CTAS is a terse method to get a test-case.

http://www.orafaq.com/wiki/CTAS http://dev.mysql.com/doc/refman/8.0/en/create-table-select.html https://www.postgresql.org/docs/current/static/sql-createtableas.html

history | excerpt history