Difference between revisions of "SQL System Tables"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) (→Description) |
||
(9 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
System-defined read-only views | System-defined read-only views | ||
− | |||
==See Also== | ==See Also== | ||
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]] | [[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]] | ||
− | |||
==Description== | ==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. | 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. | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | |
!Table||Remarks | !Table||Remarks | ||
|- | |- | ||
Line 18: | Line 15: | ||
|[[SYSALERTS]]||Alert records for watched records | |[[SYSALERTS]]||Alert records for watched records | ||
|- | |- | ||
− | |[[SYSBESTROWIDENTIFIER]]||Description of a table’s optimal set of columns that uniquely identifies a row | + | |[[SYSAPPS]]||Lianja Cloud Server [[A Guide to Deploying Web Apps|deployed Apps]] |
+ | |- | ||
+ | |valign="top"|[[SYSBACKUPS]]||Database snapshots. Also see [[Lianja Cloud Admin Console]] for more information | ||
+ | |- | ||
+ | |valign="top"|[[SYSBESTROWIDENTIFIER]]||Description of a table’s optimal set of columns that uniquely identifies a row | ||
|- | |- | ||
|[[SYSCATALOGS]]||Catalog names available in the database | |[[SYSCATALOGS]]||Catalog names available in the database | ||
|- | |- | ||
− | |[[SYSCOLUMNCONSTRAINTS]]||Description of the constraints for a table’s columns | + | |valign="top"|[[SYSCOLUMNCONSTRAINTS]]||Description of the constraints for a table’s columns |
|- | |- | ||
− | |[[SYSCOLUMNPRIVILEGES]]||Description of the access rights for a table’s columns | + | |valign="top"|[[SYSCOLUMNPRIVILEGES]]||Description of the access rights for a table’s columns |
|- | |- | ||
− | |[[SYSCOLUMNS]]||Description of the table columns available in the catalog | + | |valign="top"|[[SYSCOLUMNS]]||Description of the table columns available in the catalog |
|- | |- | ||
− | |[[SYSCROSSREFERENCE]]||Description of how one table imports the keys of another table | + | |valign="top"|[[SYSCROSSREFERENCE]]||Description of how one table imports the keys of another table |
|- | |- | ||
− | |[[ | + | |[[SYSDATAMASKS]]||Role based dynamic data masking |
|- | |- | ||
− | |[[SYSIMPORTEDKEYS]]||Description of the primary key columns that are referenced by the foreign key | + | |valign="top"|[[SYSEXPORTEDKEYS]]||Description of the foreign key columns that reference the primary key columns |
+ | |- | ||
+ | |[[SYSFILTERS]]||[[QueryBuilder]] filters | ||
+ | |- | ||
+ | |valign="top"|[[SYSIMPORTEDKEYS]]||Description of the primary key columns that are referenced by the foreign key | ||
|- | |- | ||
|[[SYSINDEXINFO]]||Description of a table’s indices and statistics | |[[SYSINDEXINFO]]||Description of a table’s indices and statistics | ||
|- | |- | ||
− | |[[SYSIOSTATS]]||Facility for monitoring table and index file I/O operations | + | |valign="top"|[[SYSIOSTATS]]||Facility for monitoring table and index file I/O operations |
|- | |- | ||
|[[SYSLOGGING]]||System Logging information | |[[SYSLOGGING]]||System Logging information | ||
|- | |- | ||
− | |[[SYSPRIMARYKEYS]]||Description of the primary key columns in the table | + | |[[SYSPACKAGES]]||Lianja Cloud Server [[Lianja_Package_Manager#Lianja_Cloud_Server|Package files]] |
+ | |- | ||
+ | |[[SYSPERMS]]||Dynamic roles and permissions | ||
+ | |- | ||
+ | |valign="top"|[[SYSPRIMARYKEYS]]||Description of the primary key columns in the table | ||
+ | |- | ||
+ | |valign="top"|[[SYSPROCEDURECOLUMNS]]||Description of the input, output and results associated with certain stored procedures available | ||
+ | |- | ||
+ | |valign="top"|[[SYSPROCEDURES]]||Description of the stored procedures available in the catalog | ||
+ | |- | ||
+ | |[[SYSREPORTS]]||Lianja Cloud Server deployed [[Reports_Workspace|reports]] | ||
|- | |- | ||
− | |[[ | + | |valign="top"|[[SYSRESULTSET]]||Used to return the singleton result from any Lianja expression |
|- | |- | ||
− | |[[ | + | |[[SYSROLES]]||Users and roles |
|- | |- | ||
− | |[[ | + | |[[SYSROWFILTERS]]||Role based row level filters |
|- | |- | ||
|[[SYSSCHEMAS]]||Schema names available in the database | |[[SYSSCHEMAS]]||Schema names available in the database | ||
|- | |- | ||
− | |[[SYSTABLECONSTRAINTS]]||Description of the constraints for each table available in the catalog | + | |valign="top"|[[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 | + | |valign="top"|[[SYSTABLEPRIVILEGES]]||Description of the access rights for each table available in the catalog |
|- | |- | ||
|[[SYSTABLES]]||Description of the tables available in the catalog | |[[SYSTABLES]]||Description of the tables available in the catalog | ||
Line 60: | Line 75: | ||
|[[SYSTIMELINE]]||Timeline records for timelined tables | |[[SYSTIMELINE]]||Timeline records for timelined tables | ||
|- | |- | ||
− | |[[SYSTYPEINFO]]||Description of all data types supported by the database | + | |valign="top"|[[SYSTYPEINFO]]||Description of all data types supported by the database |
|- | |- | ||
− | |[[SYSUDTS]]||Description of the user-defined types (UDTs) defined in the schema | + | |valign="top"|[[SYSUDTS]]||Description of the user-defined types (UDTs) defined in the schema |
|- | |- | ||
− | |[[SYSUSERS]]||Username and email information for alerts for watched records | + | |valign="top"|[[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 | + | |valign="top"|[[SYSVERSIONCOLUMNS]]||Description of the columns in a table that are automatically updated when any row is updated |
|- | |- | ||
|} | |} | ||
Line 73: | Line 88: | ||
[[Category:System Tables]] | [[Category:System Tables]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
+ | [[Category:Lianja SQL]] |
Latest revision as of 07:46, 27 May 2020
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 |
SYSAPPS | Lianja Cloud Server deployed Apps |
SYSBACKUPS | Database snapshots. Also see Lianja Cloud Admin Console for more information |
SYSBESTROWIDENTIFIER | Description of a table’s optimal set of columns that uniquely identifies a row |
SYSCATALOGS | Catalog names available in the database |
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 catalog |
SYSCROSSREFERENCE | Description of how one table imports the keys of another table |
SYSDATAMASKS | Role based dynamic data masking |
SYSEXPORTEDKEYS | Description of the foreign key columns that reference the primary key columns |
SYSFILTERS | QueryBuilder filters |
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 |
SYSPACKAGES | Lianja Cloud Server Package files |
SYSPERMS | Dynamic roles and permissions |
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 |
SYSREPORTS | Lianja Cloud Server deployed reports |
SYSRESULTSET | Used to return the singleton result from any Lianja expression |
SYSROLES | Users and roles |
SYSROWFILTERS | Role based row level filters |
SYSSCHEMAS | Schema names available in the database |
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 catalog |
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 |