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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite system table reference


UltraLite system tables

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

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

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 Tables 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