Skip to main content

INFORMATION.SCHEMA.SCHEMATA

persistent class INFORMATION.SCHEMA.SCHEMATA extends %Library.Persistent

SQL Table Name: INFORMATION_SCHEMA.SCHEMATA

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

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property CATALOGNAME as %String (MAXLEN = 128) [ Calculated , SqlFieldName = CATALOG_NAME ];
Catalog name - always NULL in InterSystems IRIS.
Property methods: CATALOGNAMECompute(), CATALOGNAMEDisplayToLogical(), CATALOGNAMEGet(), CATALOGNAMEIsValid(), CATALOGNAMELogicalToDisplay(), CATALOGNAMELogicalToOdbc(), CATALOGNAMENormalize(), CATALOGNAMESQLCompute()
property DEFAULTCHARACTERSETCATALOG as %String (MAXLEN = 128) [ Calculated , SqlFieldName = DEFAULT_CHARACTER_SET_CATALOG ];
Catalog name of the default character set for columns and domains in the schemata. Always NULL in InterSystems IRIS.
Property methods: DEFAULTCHARACTERSETCATALOGCompute(), DEFAULTCHARACTERSETCATALOGDisplayToLogical(), DEFAULTCHARACTERSETCATALOGGet(), DEFAULTCHARACTERSETCATALOGIsValid(), DEFAULTCHARACTERSETCATALOGLogicalToDisplay(), DEFAULTCHARACTERSETCATALOGLogicalToOdbc(), DEFAULTCHARACTERSETCATALOGNormalize(), DEFAULTCHARACTERSETCATALOGSQLCompute()
property DEFAULTCHARACTERSETNAME as %String (MAXLEN = 128) [ Calculated , SqlFieldName = DEFAULT_CHARACTER_SET_NAME ];
Name of the default character set for columns and domains in the schemata. Always NULL in InterSystems IRIS.
Property methods: DEFAULTCHARACTERSETNAMECompute(), DEFAULTCHARACTERSETNAMEDisplayToLogical(), DEFAULTCHARACTERSETNAMEGet(), DEFAULTCHARACTERSETNAMEIsValid(), DEFAULTCHARACTERSETNAMELogicalToDisplay(), DEFAULTCHARACTERSETNAMELogicalToOdbc(), DEFAULTCHARACTERSETNAMENormalize(), DEFAULTCHARACTERSETNAMESQLCompute()
property DEFAULTCHARACTERSETSCHEMA as %String (MAXLEN = 128) [ Calculated , SqlFieldName = DEFAULT_CHARACTER_SET_SCHEMA ];
Schema name of the default character set for columns and domains in the schemata. Always NULL in InterSystems IRIS.
Property methods: DEFAULTCHARACTERSETSCHEMACompute(), DEFAULTCHARACTERSETSCHEMADisplayToLogical(), DEFAULTCHARACTERSETSCHEMAGet(), DEFAULTCHARACTERSETSCHEMAIsValid(), DEFAULTCHARACTERSETSCHEMALogicalToDisplay(), DEFAULTCHARACTERSETSCHEMALogicalToOdbc(), DEFAULTCHARACTERSETSCHEMANormalize(), DEFAULTCHARACTERSETSCHEMASQLCompute()
property SCHEMANAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = SCHEMA_NAME , Required ];
Name of the schema.
Property methods: SCHEMANAMEDisplayToLogical(), SCHEMANAMEGet(), SCHEMANAMEIsValid(), SCHEMANAMELogicalToDisplay(), SCHEMANAMELogicalToOdbc(), SCHEMANAMENormalize(), SCHEMANAMESet()
property SCHEMAOWNER as %String (MAXLEN = 128) [ Calculated , SqlFieldName = SCHEMA_OWNER ];
Owner of the schema - always NULL in InterSystems IRIS.
Property methods: SCHEMAOWNERCompute(), SCHEMAOWNERDisplayToLogical(), SCHEMAOWNERGet(), SCHEMAOWNERIsValid(), SCHEMAOWNERLogicalToDisplay(), SCHEMAOWNERLogicalToOdbc(), SCHEMAOWNERNormalize(), SCHEMAOWNERSQLCompute()
property SQLPATH as %String (MAXLEN = 128) [ Calculated , SqlFieldName = SQL_PATH ];
Reserved for future use. Always NULL in InterSystems IRIS.
Property methods: SQLPATHCompute(), SQLPATHDisplayToLogical(), SQLPATHGet(), SQLPATHIsValid(), SQLPATHLogicalToDisplay(), SQLPATHLogicalToOdbc(), SQLPATHNormalize(), SQLPATHSQLCompute()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: SQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("schema",{SchemaUpper})
    =
    Node Delimiter Piece Name
    SCHEMA_NAME
FeedbackOpens in a new tab