For information about the FROM TABLE option, which is similar to the WITH DATA AND STATISTICS option for CREATE TABLE … AS, see COLLECT STATISTICS (Optimizer Form).
For information about the syntax used to copy a table definition and its data and statistics, see “CREATE TABLE” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
For information about using CREATE TABLE (AS Clause) with ALTER TABLE to modify existing tables, see ALTER TABLE (Basic Table Parameters).
For syntax information related to using CREATE TABLE (AS Clause) to modify existing tables, see “ALTER TABLE” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.