persistent class INFORMATION.SCHEMA.TABLES extends %Library.Persistent
SQL Table Name: INFORMATION_SCHEMA.TABLESReturns one row for each table in the current namespace for which the current user has privileges.
- YES - The table being described is insertable-into.
- NO - The table being described is not insertable-into.
A table RT whose row type is derived from a structured type ST is called a typed table. Only a base table or a view can be a typed table. A typed table has columns corresponding, in name and declared type, to every attribute of ST and one other column REFC that is the self-referencing column of RT; let REFCN be theInterSystems IRIS does not currently support typed tables, therefore IS_TYPED is always NO.
of REFC. The declared type of REFC is necessarily REF(ST) and the nullability characteristic of REFC is known not nullable. If RT is a base table, then the table constraint "UNIQUE(REFCN)" is implicit in the definition of RT. A typed table is called a referenceable table. A self-referencing column cannot be updated. Its value is determined during the insertion of a row into the referenceable table. The value of a system-generated self-referencing column and a derived self-referencing column is automatically generated when the row is inserted into the referenceable table. The value of a user-generated self-referencing column is supplied as part of the candidate row to be inserted into the referenceable table.
The values of REFERENCE_GENERATION have the following meanings: SYSTEM GENERATED - The values of the self-referencing column of the table are generated by the SQL-server. USER GENERATED - The values of the self-referencing column of the table are generated by the user. DERIVED - The values of the self-referencing column of the table are generated from columns of the table. null - The table being described does not have a self-referencing column.Since InterSystems IRIS does not support self-referencing columns, REFERENCE_GENERATION is always null.
The value of SELF_REFERENCING_COLUMN_NAME is the name of the self-referencing column of the table, if the table is a typed table. Otherwise, the value of SELF_REFERENCING_COLUMN_NAME is the null value.Since InterSystems IRIS does not currently support typed table (see IS_TYPED), SELF_REFERENCING_COLUMN_NAME is always NULL
- BASE TABLE - The table being described is a persistent base table.
- SYSTEM TABLE - The table being described is a system persistent base table.
- VIEW - The table being described is a viewed table.
- SYSTEM VIEW - The table being described is a viewed table.
- GLOBAL TEMPORARY - The table being described is a global temporary table.
- LOCAL TEMPORARY - The table being described is a created local temporary table.
If the table being described is a table of a structured type TY, then the values of USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, and USER_DEFINED_TYPE_NAME are the fully qualified name of TY; otherwise, the values of USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, and USER_DEFINED_TYPE_NAME are the null value.For InterSystems IRIS, USER_DEFINED_TYPE_CATALOG is always NULL.
Gray indicates storage defined by superclasses.
Storage Model: SQLStorage
Map number 1 is named Master
Map number 2 is named rxIndex