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.

To browse UltraLite table (Sybase Central)

  1. Connect to the UltraLite database.

  2. If system tables are hidden and you want to browse the data in one or more tables, right-click the white space of the Contents pane and choose Show System Objects.

  3. To view a list of tables, double-click Tables.

  4. To view table data, double-click a table and click the Data tab in the right pane.

To filter UltraLite system tables (Sybase Central)

  1. Connect to the UltraLite database.

  2. Right-click the database you are connected to and choose either Hide System Objects or Show System Objects.

Interactive SQL

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

To browse UltraLite user tables (Interactive SQL)

  1. Connect to a database.

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

To browse UltraLite system tables (Interactive SQL)

  1. Connect to a database.

  2. 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;
See also