Create Like

Go Up to Available object actions by DBMS

The Create Like Editor lets you create a new object based on an existing object. The following table shows availability of the Create Like function for particular object types by DBMS:

DB2 LUW	DB2 Z/OS	MySQL	SQL Server	Oracle	Sybase ASE
Materialized Query Tables Tables	Tables	Tables	Logins Tables Users	Tables	Logins Tables Users

To Create an Object Bbased on Another Object

1. Initiate a Create Like action against a table. For more information see Initiating an object operation.

   A Create Like wizard opens.

2. Provide a name for the new object.
3. Modify settings on each panel of the wizard as required.

   For particular object types, tasks and settings on the panels of the Create Like wizard are similar to those for the object editors for that object type. For information, see:

   • Materialized Query Tables Editor (IBM DB2 LUW)
   • Tables Editor (IBM DB2 LUW)
   • Tables Editor (IBM DB2 Z/OS)

• Tables Editor (MySQL)
• Logins Editor (SQL Server)
• Tables Editor (SQL Server)
• Users Editor (SQL Server)
• Tables Editor (Oracle)
• Logins Editor (Sybase ASE)
• Tables Editor (Sybase ASE)
• Users Editor (Sybase ASE)

4. Click Execute to create the new object.