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.
In Sybase Central, you can perform these tasks while working with a selected database.
Connect to the UltraLite database.
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.
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.
Connect to the UltraLite database.
Right-click the database you are connected to and choose either Hide System Objects or Show System Objects.
In Interactive SQL, you can perform these tasks with the SELECT statement.
Connect to a database.
Execute a SELECT statement, specifying the user table you want to browse.
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; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |