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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference

UltraLite system tables

The schema of an UltraLite database is stored in a proprietary format.

Earlier versions of UltraLite databases were stored in several system tables. These system tables (system views) can still be queried for backward compatibility, but they only contain information about user schema (like tables, columns, indexes) not system schema. For example, you cannot query the systable to find the properties of systable itself. You can only query the systable to find the properties of user-created tables.

Each UltraLite programming API supports objects and methods that can be used to query the database about its schema. Use these objects and APIs to explore schema rather than querying the system views.

All queries performed on these system views are equivalent to full table scans. Index scans are not supported on these system views.