Skip to main content

INFORMATION.SCHEMA.SCHEMATA

Class INFORMATION.SCHEMA.SCHEMATA Extends %Library.Persistent [ ClassType = persistent, Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = SCHEMATA, StorageStrategy = SQLStorage, System = 4 ]

Returns one row for each schema in the current namespace where the current user has privileges for any object in the namespace.

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

SchemaUpper​

Property SchemaUpper As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 10 ];

SystemSchema​

Property SystemSchema As %Integer [ Calculated, Internal, Private, Required, SqlColumnNumber = 11, SqlComputeCode = { set {*}=$s($e({SCHEMA_NAME})="%"||({SCHEMA_NAME}="INFORMATION_SCHEMA"):1,1:0) }, SqlComputed ];

Is the table a system schema (1 or 0)

CATALOGNAME​

Property CATALOGNAME As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 2, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = CATALOG_NAME ];

Catalog name - always NULL in InterSystems IRIS.

SCHEMANAME​

Property SCHEMANAME As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 3, SqlFieldName = SCHEMA_NAME ];

Name of the schema.

SCHEMAOWNER​

Property SCHEMAOWNER As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 4, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = SCHEMA_OWNER ];

Owner of the schema - always NULL in InterSystems IRIS.

DEFAULTCHARACTERSETCATALOG​

Property DEFAULTCHARACTERSETCATALOG As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 5, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = DEFAULT_CHARACTER_SET_CATALOG ];

Catalog name of the default character set for columns and domains in the schemata. Always NULL in InterSystems IRIS.

DEFAULTCHARACTERSETSCHEMA​

Property DEFAULTCHARACTERSETSCHEMA As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 6, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = DEFAULT_CHARACTER_SET_SCHEMA ];

Schema name of the default character set for columns and domains in the schemata. Always NULL in InterSystems IRIS.

DEFAULTCHARACTERSETNAME​

Property DEFAULTCHARACTERSETNAME As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 7, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = DEFAULT_CHARACTER_SET_NAME ];

Name of the default character set for columns and domains in the schemata. Always NULL in InterSystems IRIS.

SQLPATH​

Property SQLPATH As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 8, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = SQL_PATH ];

Reserved for future use. Always NULL in InterSystems IRIS.