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.