Copy foreign table | CREATE TABLE | Teradata Vantage - Copying Foreign Tables - Advanced SQL Engine - Teradata Database

To create a copy of a foreign table with same options as an existing foreign table, use the statement CREATE TABLE AS. The form of CREATE TABLE AS determines whether you must use the WITH NO DATA clause:

• CREATE TABLE new_foreign_table AS original_foreign_table

  You must use the WITH NO DATA clause.

• CREATE TABLE new_foreign_table AS (SELECT select_list FROM original_foreign_table)

  You can use either the WITH NO DATA or WITH DATA clause.

To copy the payload data from original_foreign_table into columns of new_foreign_table:

1. Create a view of the foreign table and use CAST to name the columns.
2. Use the INSERT … SELECT statement to copy the payload data into the columns.