Creating a table from other tables
You can create a table from other tables in two ways:.
You can create a table from other tables in two ways:
-
Replicate an existing table through
CREATE TABLE...LIKE. -
Create a table from a query through
CREATE TABLE...AS.
Important
You can also copy one table to another with the Vertica functionCOPY_TABLE.