Introduction

System Catalog Tables

In This Chapter

Objects That the System Catalog Tables Track

Using the System Catalog

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

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)

Data Types

Environment Variables

Appendix A. The stores_demo Database

Appendix B. The sales_demo and superstores_demo Databases

Appendix C. Accessibility

Glossary

Notices

Index