Home > Class Reference > %SYS namespace > INFORMATION.SCHEMA.SCHEMATA
Private   Storage    

INFORMATION.SCHEMA.SCHEMATA

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 7

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 Caché.
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 Caché.
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 Caché.
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 Caché.
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 Caché.
property SQLPATH as %String(MAXLEN=128) [ Calculated,SqlFieldName = SQL_PATH ];
Reserved for future use. Always NULL in Caché.