ASA SQL User's Guide
  Working with Database Objects

Copying database objects in Sybase Central

In Sybase Central, you can copy existing database objects and insert them into another location in the same database or in a completely different database.

To copy an object, select the object in the left pane of Sybase Central and drag it to the appropriate folder or container, or copy the object and then paste it in the appropriate folder or container. A new object is created, and the original object's code is copied to the new object. When copying objects within the same database, you must rename the new object.

You can also paste objects onto other objects in the database. For example, if you paste a table onto a user, this gives the user permissions on the table.

Copying a database object's code for use in other applications 

In Sybase Central, when you copy any of the objects from the following list, the SQL for the object is copied to the clipboard so it can be pasted into other applications, such as Interactive SQL or a text editor. For example, if you copy an index in Sybase Central and paste it into a text editor, the CREATE INDEX statement for that index appears.

• Articles

• Check constraints

• Columns (Copy button only)

• Domains

• Events

• External logins

• Foreign keys

• Indexes

• Message types

• Procedures and functions

• Publications

• Remote servers

• System triggers

• Tables

• Triggers

• UltraLite projects

• UltraLite statements

• Unique constraints

• Users

• Views

• Web services