Home | Previous Page | Next Page  

System Catalog Tables

In This Chapter
Objects That the System Catalog Tables Track
Using the System Catalog
Accessing the System Catalog
Updating System Catalog Data
Structure of the System Catalog
SYSAGGREGATES (IDS Only)
SYSAMS (IDS Only)
SYSATTRTYPES (IDS Only)
SYSBLOBS
SYSCASTS (IDS Only)
SYSCHECKS
SYSCHECKUDRDEP (IDS Only)
SYSCOLATTRIBS (IDS Only)
SYSCOLAUTH
SYSCOLDEPEND
SYSCOLUMNS
NOT NULL Constraints
Storing the Column Data Type
Opaque Data Types (IDS Only)
Storing Column Length
Integer-Based Data Types
Varying-Length Character Data Types
Time Data Types
Fixed-Point Data Types
Simple-Large-Object Data Types
Storing Maximum and Minimum Values
SYSCONSTRAINTS
SYSDEFAULTS
SYSDEPEND
SYSDISTRIB
SYSDOMAINS (IDS Only)
SYSERRORS (IDS Only)
SYSEXTCOLS (XPS Only)
SYSEXTDFILES (XPS Only)
SYSEXTERNAL (XPS Only)
SYSFRAGAUTH (IDS Only)
SYSFRAGMENTS
SYSINDEXES
SYSINDICES (IDS Only)
SYSINHERITS (IDS Only)
SYSLANGAUTH (IDS Only)
SYSLOGMAP (IDS Only)
SYSNEWDEPEND (XPS Only)
SYSOBJSTATE (IDS Only)
SYSOPCLASSES (IDS Only)
SYSOPCLSTR
SYSPROCAUTH
SYSPROCBODY
SYSPROCEDURES
SYSPROCPLAN
SYSREFERENCES
SYSREPOSITORY (XPS Only)
SYSROLEAUTH
SYSROUTINELANGS (IDS Only)
SYSSEQUENCES (IDS Only)
SYSSYNONYMS
SYSSYNTABLE
SYSTABAMDATA (IDS Only)
SYSTABAUTH
SYSTABLES
SYSTRACECLASSES (IDS Only)
SYSTRACEMSGS (IDS Only)
SYSTRIGBODY
SYSTRIGGERS
SYSUSERS
SYSVIEWS
SYSVIOLATIONS
SYSXTDDESC (IDS Only)
SYSXTDTYPEAUTH (IDS Only)
SYSXTDTYPES (IDS Only)
Information Schema (IDS Only)
Generating the Information Schema Views
Accessing the Information Schema Views
Structure of the Information Schema Views
The tables Information Schema View
The columns Information Schema View
The sql_languages Information Schema View
The server_info Information Schema View
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]