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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite System Table Reference

UltraLite System Table Reference Next Page

UltraLite system tables

The schema of every UltraLite database is described in a number of system tables. Because UltraLite does not support table ownership, system tables are available to any of the four UltraLite user IDs.

The contents of these tables can be changed only by UltraLite itself. Therefore, UPDATE, DELETE, and INSERT commands cannot be used to modify the contents of these tables. Further, the structure of these tables cannot be changed using the ALTER TABLE and DROP commands.

You can browse the contents of these tables via Sybase Central.

To hide or show system objects (Sybase Central)
  1. Connect to the database.

  2. Browse the objects of the database.

  3. Right-click the contents pane and choose Hide/Show System Objects.

  4. Click the Tables folder and browse the available tables.

systable system table
syscolumn system table
sysindex system table
sysixcol system table
syspublication system table
sysarticle system table
sysuldata system table