Creating a Table from Other Tables
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.
You can also copy one table to another with the Vertica function COPY_TABLE.