|Previous Top Next|
( Pro Edition )
The Duplicate Object tool can be used to quickly create an identical copy of any existing object - simply use the context menu in the Database Navigator and select Duplicate - enter a new name and of you go!
You will be asked to edit the object, which might be very useful if you're, for example, duplicating a trigger that contains the table name - source code of the original object will not be changed.
The Duplicate Object dialog
If the object is a table, the Options will become enabled. If you want to Edit object before saving, you cannot automatically include the data.
If the database system has no separate namespace for Indices, Constraints or Triggers, you will be required to re-name the included child objects before saving the table.