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
- Initiate a Create Like action against a table. For more information see Initiating an object operation.
- A Create Like wizard opens.
- Provide a name for the new object.
- 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:
- 4. Click Execute to create the new object.