|
With Sybase Central, you have different copying and pasting as well as dragging and dropping options for tables or columns. This allows you to share or move objects among one or more databases. By copying and pasting or dragging and dropping you can share data as described by the table that follows.
| Target | Result |
|---|---|
| Another UltraLite/SQL Anywhere database. | A new object is created, and the original object's code is copied to the new object. |
| The same UltraLite database. | A copy of the object is created; you must rename the new object. |
NoteYou can copy data from a database opened in MobiLink and paste it into an UltraLite database. However, you cannot paste UltraLite data into a database opened in MobiLink. |
In Sybase Central, when you copy any of the objects from the list that follows, 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
Columns
Foreign keys
Indexes
Publications
Tables
Unique constraints
With Interactive SQL, you can also copy data from a result set into a another objects.
Use the SELECT statement results into a named object.
Use the INSERT statement to insert a row or selection of rows from elsewhere in the database into a table.