Using the SAMEAS Clause

The SAMEAS template clause uses all the column names and data types from the template table in the definition of new table. You cannot, however, use indexes in the external table definition, and you cannot use the SAMEAS clause for FIXED-format files.