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
Note:
Any sub-objects, like indices and constraints, currently will not be duplicated.