Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases » Working with UltraLite tables and columns

Browsing the information in UltraLite tables Next Page

Copying and pasting data to/from UltraLite databases

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.

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.

You 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.

Sybase Central

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.

Interactive SQL

With Interactive SQL, you can also copy data from a result set into a another objects.

See also