In the SQL Anywhere 12 plug-in, 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.

Note when you create a copy of a view, only the view definition is copied to the new location. Other view properties, such as permissions, are not copied.

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.

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. You can copy the following objects in the SQL Anywhere 12 plug-in:

• Articles
• Check constraints
• Columns
• Dbspaces
• Directory access servers
• Domains
• Events
• External environments
• External logins
• Foreign keys
• Indexes
• Login mappings (integrated logins and Kerberos logins)
• Login policies
• Maintenance plan reports
• Maintenance plans
• Message types
• MobiLink users
• Primary keys
• Procedures and functions
• Publications
• Remote servers
• Schedules
• Sequence Generators
• Spatial Reference Systems
• Spatial Units of Measure
• SQL Remote subscriptions
• Synchronization subscriptions
• System triggers
• Text configuration objects
• Text indexes
• Tables
• Triggers
• Unique constraints
• Users and groups
• Views
• Web services