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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite Database Reference


UltraLite system tables

The schema of every UltraLite database is described in several 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.

View or hide UltraLite system tables
systable system table
syscolumn system table
sysindex system table
sysixcol system table
syspublication system table
sysarticle system table
sysuldata system table