Summary of Data Dictionary Tables
translation of id to function or module name. See API_FUNCTION. binary representation of the search condition of views in the database (for internal use). See AST_CODES. textual representation of view definitions and tables and domains with check constraints. See AST_SOURCES. databank backups recorded in the database. See BACKUPS. character sets in the database. See CHAR_SETS. check constraints defined for tables and domains. See CHECK_CONSTRAINTS. character collations in the database. See COLLATIONS. columns in tables or views. See COLUMNS. columns that depend on other database objects. See COLUMN_OBJECT_USE. instances of privileges granted on a column. See COLUMN_PRIVILEGES. databanks in the database. See DATABANKS. domains in the database. See DOMAINS. constraints defined for domains. See DOMAIN_CONSTRAINTS details about all FIPS features. See FIPS_FEATURES. details about FIPS limits. See FIPS_SIZING. columns in an index or in a primary, unique or foreign key. KEY_COLUMN_USAGE. restrictions for domains legal for use by DB level 2. See LEVEL2_RESTRICT. columns of views acceptable by DB level 2. See LEVEL2_VIEWCOL. restrictions for DB level 2. See LEVEL2_VIEWRES. dummy table with more than one row. See MANYROWS. translation of message code to message text. See MESSAGE. SQL-server modules in the database. See MODULES. objects in the database. See OBJECTS. columns referenced by other database objects. See OBJECT_COLUMN_USE. objects that have a dependency on another object. See OBJECT_OBJECT_USE. dummy table containing one row. See ONEROW. parameters of routines in the database. See PARAMETERS. referential constraints in the database. See REFER_CONSTRAINTS. procedures and user-defined functions in the database. See ROUTINES. schemas in the database. See SCHEMATA. sequences in the database. See SEQUENCES. attributes of the current database system or server. See SERVER_INFO. severity levels and optional module for error codes. See SEVERITY. source definitions for defaults, check constraints, views, modules, procedures, functions and triggers. See SOURCE_DEFINITION. specific names of the routines in the database. See SPECIFIC_NAMES. SQL standards and SQL dialects supported. See SQL_LANGUAGES. synonyms and shadows in the database. See SYNONYMS. tables and views in the database. See TABLES. table constraints in the database. See TABLE_CONSTRAINTS. instances of privileges granted on a table. See TABLE_PRIVILEGES. the types of table supported. See TABLE_TYPES. character translations in the database. See TRANSLATIONS. table columns explicitly specified in an UPDATE trigger event. See TRIGGERED_COLUMNS. triggers in the database. See TRIGGERS. information about data types supported. See TYPE_INFO. instances of privileges which grant the right to use a database object. See USAGE_PRIVILEGES. idents (group, OS_USER, program or user) in the database. See USERS. views in the database. See VIEWS.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40