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)
SYSAMS (IDS)
SYSATTRTYPES (IDS)
SYSBLOBS
SYSCASTS (IDS)
SYSCHECKS
SYSCHECKUDRDEP (IDS)
SYSCOLATTRIBS (IDS)
SYSCOLAUTH
SYSCOLDEPEND
SYSCOLUMNS
NOT NULL Constraints
Storing the Column Data Type
Opaque Data Types (IDS)
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
SYSDIRECTIVES (IDS)
SYSDISTRIB
SYSDOMAINS (IDS)
SYSERRORS (IDS)
SYSEXTCOLS (XPS)
SYSEXTDFILES (XPS)
SYSEXTERNAL (XPS)
SYSFRAGAUTH (IDS)
SYSFRAGMENTS
SYSINDEXES
SYSINDICES (IDS)
SYSINHERITS (IDS)
SYSLANGAUTH (IDS)
SYSLOGMAP (IDS)
SYSNEWDEPEND (XPS)
SYSOBJSTATE (IDS)
SYSOPCLASSES (IDS)
SYSOPCLSTR
SYSPROCAUTH
SYSPROCBODY
SYSPROCEDURES
SYSPROCPLAN
SYSREFERENCES
SYSREPOSITORY (XPS)
SYSROLEAUTH
SYSROUTINELANGS (IDS)
SYSSEQUENCES (IDS)
SYSSYNONYMS
SYSSYNTABLE
SYSTABAMDATA (IDS)
SYSTABAUTH
SYSTABLES
SYSTRACECLASSES (IDS)
SYSTRACEMSGS (IDS)
SYSTRIGBODY
SYSTRIGGERS
SYSUSERS
SYSVIEWS
SYSVIOLATIONS
SYSXTDDESC (IDS)
SYSXTDTYPEAUTH (IDS)
SYSXTDTYPES (IDS)
Information Schema (IDS)
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 ]