Browsing the information in UltraLite tables

You can use Sybase Central or Interactive SQL to browse the data held within the tables of an UltraLite database. Tables can be user tables or system tables. You can filter tables by showing and hiding system tables from your current view of the database. Because UltraLite does not have a concept of ownership, all users can browse all tables.

Sybase Central

In Sybase Central, you can perform these tasks while working with a selected database.

Browse an UltraLite table (Sybase Central)

Connect to the UltraLite database.
To view a list of tables, double-click Tables.
To view table data, double-click a table and click the Data tab in the right pane.

Interactive SQL

In Interactive SQL, you can perform these tasks with the SELECT statement.

Browse UltraLite user tables (Interactive SQL)

Connect to a database.
Execute a SELECT statement, specifying the user table you want to browse.

Browse UltraLite system tables (Interactive SQL)

Connect to a database.
Execute a SELECT statement, by the system table you want to browse.

For example, to display the contents of the table systable on the Results tab in the Results pane in Interactive SQL, execute the following command:
SELECT * FROM SYSTABLE;