ASA SQL User's Guide
Working with Database Objects
Working with tables
With Sybase Central, you can copy existing tables or columns and insert them into another location in the same database or into a completely different database.
If you are not using Sybase Central, see one of the following locations:
To insert SELECT statement results into a given location, see SELECT statement.
To insert a row or selection of rows from elsewhere in the database into a table, see INSERT statement.