Collection Contents Index Using subqueries instead of joins The SYSCATALOG table pdf/chap18.pdf

First Guide to SQL Anywhere Studio
   PART 3. Basic SQL     

CHAPTER 18. System Tables


About this chapter 

This chapter describes the system tables, several special tables found in every Adaptive Server Anywhere database. These system tables describe all the tables and columns in the database. The database server automatically updates the system table as the database structure is changed.


  The SYSCATALOG table
  The SYSCOLUMNS table
  Other system tables

Collection Contents Index Using subqueries instead of joins The SYSCATALOG table pdf/chap18.pdf