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

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 doesn't have a notion of ownership, all users can browse all tables.

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 background of the Contents pane and choose Show System Objects.

3. To display tables, click Tables.

4. To browse the data of a Table, double-click a table name.

5. 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 name you are connected to and click 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.

   Example    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

• UltraLite System Table Reference