This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases
I want to create a new table that have the same structure of an existing table. I don't want the records to be inserted in new table. I want only the structure of existing table.
SQL:2003 says: CREATE TABLE new_table_name [(column_names)] AS <subquery> WITH [NO] DATA. DB2 uses CREATE TABLE new_table_name LIKE old_table_name; both is irrelevant to the INSERT statement, however. --Stolze10:56, 30 October 2006 (UTC)[reply]
