Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [INFORMATION] >  [SCHEMA] >  [SCHEMATA]
Private  Storage   

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

SQL Table Name: SCHEMATA

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

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 9


Summary

Properties
CATALOGNAME DEFAULTCHARACTERSETCATALOG DEFAULTCHARACTERSETNAME DEFAULTCHARACTERSETSCHEMA
SCHEMANAME SCHEMAOWNER SQLPATH

Methods
%AddToSaveSet %AddToSyncSet %CheckConstraints %CheckConstraintsForExtent
%ClassIsLatestVersion %ClassName %ComposeOid %ConstructClone
%Delete %DeleteExtent %DeleteId %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod %DispatchSetModified
%DispatchSetMultidimProperty %DispatchSetProperty %Exists %ExistsId
%Extends %GUID %GUIDSet %GetLock
%GetParameter %GetSwizzleObject %Id %IsA
%IsModified %IsNull %KillExtent %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SerializeObject
%SetModified %SortBegin %SortEnd %SyncObjectIn
%SyncTransport %UnlockExtent %UnlockId %ValidateIndices
%ValidateObject


Parameters

• parameter READONLY = 1;
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 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 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 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 SCHEMANAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = SCHEMA_NAME,Required ];
Name of the schema.
• property SCHEMAOWNER as %String(MAXLEN=128) [ Calculated,SqlFieldName = SCHEMA_OWNER ];
Owner of the schema - always NULL in InterSystems IRIS.
• property SQLPATH as %String(MAXLEN=128) [ Calculated,SqlFieldName = SQL_PATH ];
Reserved for future use. Always NULL in InterSystems IRIS.


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.