Loading Data

Use Interactive SQL or Sybase Central to load your tables.

Interactive SQL

To load a table with Interactive SQL, use:

INSERT FROM SELECT loads information from a database or attached database.
INSERT VALUES inserts data manually into specified table columns.
LOAD inserts ASCII and binary data from files as well as data from backups and upgrades.

Syntax and examples for the INSERT and LOAD commands are in Reference: Statements and Options.

To add a row to a table using Sybase Central:

In Folder view, open the Tables folder, click the table you want to update, then click the Data tab in the right pane. Right-click a row, and choose Add.
In Tasks view, double-click the Tables folder, choose the table you want to update, then click the Data tab. Right-click a row, and choose Add.