How to create a table TAB2 having same attributes & columns as for table TAB1

DB2 gives us an option to copy the structure of an existing table to a new table. To copy the attributes and column of table TAB1 to a new table TAB2 we can use the following command−


The CREATE TABLE reserved words are followed by table name. The table name needs to be qualified by a database in which it will reside. In this case this new table is TAB2 and its database is DBSET1.

The LIKE parameter is used after that followed by the name of the original table qualified by its database i.e. DBSET1.TAB1

The important point to note here is, primary and foreign keys are not inherited automatically and we have to define them using the ALTER table command on the new table.

Updated on: 12-Sep-2020


Kickstart Your Career

Get certified by completing the course

Get Started