Difference between revisions of "SQL System Tables"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Barrymavin (Talk | contribs) |
||
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
System-defined read-only views | System-defined read-only views | ||
| Line 11: | Line 4: | ||
==See Also== | ==See Also== | ||
| − | [[DATA TYPES]], [[SQL SELECT|SELECT]] | + | [[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]] |
| Line 22: | Line 15: | ||
|- | |- | ||
|[[SYSACTIVEUSERS]]||Description of currently active users on the system | |[[SYSACTIVEUSERS]]||Description of currently active users on the system | ||
| + | |- | ||
| + | |[[SYSALERTS]]||Alert records for watched records | ||
|- | |- | ||
|[[SYSBESTROWIDENTIFIER]]||Description of a table’s optimal set of columns that uniquely identifies a row | |[[SYSBESTROWIDENTIFIER]]||Description of a table’s optimal set of columns that uniquely identifies a row | ||
|- | |- | ||
| − | |[[ | + | |[[SYSDATABASES]]||Database catalogs available |
|- | |- | ||
|[[SYSCOLUMNCONSTRAINTS]]||Description of the constraints for a table’s columns | |[[SYSCOLUMNCONSTRAINTS]]||Description of the constraints for a table’s columns | ||
| Line 31: | Line 26: | ||
|[[SYSCOLUMNPRIVILEGES]]||Description of the access rights for a table’s columns | |[[SYSCOLUMNPRIVILEGES]]||Description of the access rights for a table’s columns | ||
|- | |- | ||
| − | |[[SYSCOLUMNS]]||Description of the table columns available in the | + | |[[SYSCOLUMNS]]||Description of the table columns available in the tables in the database catalogs |
|- | |- | ||
|[[SYSCROSSREFERENCE]]||Description of how one table imports the keys of another table | |[[SYSCROSSREFERENCE]]||Description of how one table imports the keys of another table | ||
| Line 52: | Line 47: | ||
|- | |- | ||
|[[SYSRESULTSET]]||Used to return the singleton result from any Recital expression | |[[SYSRESULTSET]]||Used to return the singleton result from any Recital expression | ||
| − | |||
| − | |||
|- | |- | ||
|[[SYSTABLECONSTRAINTS]]||Description of the constraints for each table available in the catalog | |[[SYSTABLECONSTRAINTS]]||Description of the constraints for each table available in the catalog | ||
| Line 59: | Line 52: | ||
|[[SYSTABLEPRIVILEGES]]||Description of the access rights for each table available in the catalog | |[[SYSTABLEPRIVILEGES]]||Description of the access rights for each table available in the catalog | ||
|- | |- | ||
| − | |[[SYSTABLES]]||Description of the tables available in the | + | |[[SYSTABLES]]||Description of the tables available in the database catalogs |
|- | |- | ||
|[[SYSTABLETYPES]]||Table types available in the database system | |[[SYSTABLETYPES]]||Table types available in the database system | ||
| + | |- | ||
| + | |[[SYSTIMELINE]]||Timeline records for timelined tables | ||
|- | |- | ||
|[[SYSTYPEINFO]]||Description of all data types supported by the database | |[[SYSTYPEINFO]]||Description of all data types supported by the database | ||
|- | |- | ||
|[[SYSUDTS]]||Description of the user-defined types (UDTs) defined in the schema | |[[SYSUDTS]]||Description of the user-defined types (UDTs) defined in the schema | ||
| + | |- | ||
| + | |[[SYSUSERS]]||Username and email information for alerts for watched records | ||
|- | |- | ||
|[[SYSVERSIONCOLUMNS]]||Description of the columns in a table that are automatically updated when any row is updated | |[[SYSVERSIONCOLUMNS]]||Description of the columns in a table that are automatically updated when any row is updated | ||
| Line 71: | Line 68: | ||
|} | |} | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
| − | [[Category:SQL]] | + | [[Category:SQL|System Tables]] |
[[Category:System Tables]] | [[Category:System Tables]] | ||
| + | [[Category:Reference]] | ||
Latest revision as of 09:55, 4 November 2011
Purpose
System-defined read-only views
See Also
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement. The following is an alphabetical reference of the System Tables accessible to all users.
| Table | Remarks |
|---|---|
| SYSACTIVEUSERS | Description of currently active users on the system |
| SYSALERTS | Alert records for watched records |
| SYSBESTROWIDENTIFIER | Description of a table’s optimal set of columns that uniquely identifies a row |
| SYSDATABASES | Database catalogs available |
| SYSCOLUMNCONSTRAINTS | Description of the constraints for a table’s columns |
| SYSCOLUMNPRIVILEGES | Description of the access rights for a table’s columns |
| SYSCOLUMNS | Description of the table columns available in the tables in the database catalogs |
| SYSCROSSREFERENCE | Description of how one table imports the keys of another table |
| SYSEXPORTEDKEYS | Description of the foreign key columns that reference the primary key columns |
| SYSIMPORTEDKEYS | Description of the primary key columns that are referenced by the foreign key |
| SYSINDEXINFO | Description of a table’s indices and statistics |
| SYSIOSTATS | Facility for monitoring table and index file I/O operations |
| SYSLOGGING | System Logging information |
| SYSPRIMARYKEYS | Description of the primary key columns in the table |
| SYSPROCEDURECOLUMNS | Description of the input, output and results associated with certain stored procedures available |
| SYSPROCEDURES | Description of the stored procedures available in the catalog |
| SYSRESULTSET | Used to return the singleton result from any Recital expression |
| SYSTABLECONSTRAINTS | Description of the constraints for each table available in the catalog |
| SYSTABLEPRIVILEGES | Description of the access rights for each table available in the catalog |
| SYSTABLES | Description of the tables available in the database catalogs |
| SYSTABLETYPES | Table types available in the database system |
| SYSTIMELINE | Timeline records for timelined tables |
| SYSTYPEINFO | Description of all data types supported by the database |
| SYSUDTS | Description of the user-defined types (UDTs) defined in the schema |
| SYSUSERS | Username and email information for alerts for watched records |
| SYSVERSIONCOLUMNS | Description of the columns in a table that are automatically updated when any row is updated |
