Class 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.

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	9

Properties
CATALOGNAME	DEFAULTCHARACTERSETCATALOG	DEFAULTCHARACTERSETNAME	DEFAULTCHARACTERSETSCHEMA
SCHEMANAME	SCHEMAOWNER	SQLPATH

Methods
%AddToSaveSet	%AddToSyncSet	%BuildDeferredIndices	%BuildIndicesAsync
%BuildIndicesAsyncResponse	%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	%OnDeleteFinally	%OnDetermineClass
%OnOpenFinally	%OnSaveFinally	%Open	%OpenId
%OriginalNamespace	%PackageName	%PurgeIndices	%Reload
%RemoveFromSaveSet	%ResolveConcurrencyConflict	%RollBack	%Save
%SaveDirect	%SerializeObject	%SetModified	%SortBegin
%SortEnd	%SyncObjectIn	%SyncTransport	%UnlockExtent
%UnlockId	%ValidateIndices	%ValidateObject	%ValidateTable

• parameter READONLY = 1;

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

• 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.

Class Reference IRIS for UNIX 2024.1.2
Documentation Search