Class %TSQL.sys.constraints

persistent class %TSQL.sys.constraints extends %Persistent

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	6			1

Properties
colid	constrid	parentobjname	schema	status
tableid

Methods
%%OIDGet	%AddToSaveSet	%AddToSyncSet	%BuildIndices
%CheckUnique	%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	%KillExtent	%LockExtent
%LockId	%New	%NormalizeObject	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDetermineClass	%Open
%OpenId	%OriginalNamespace	%PackageName	%PurgeIndices
%Reload	%RemoveFromSaveSet	%ResolveConcurrencyConflict	%RollBack
%Save	%SaveDirect	%SerializeObject	%SetModified
%SortBegin	%SortEnd	%SyncObjectIn	%SyncTransport
%UnlockExtent	%UnlockId	%ValidateObject

• 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 colid as %TinyInt;

Column number in the table

• property constrid as %Integer;

Object ID of the constraint

• property parentobjname as %String(MAXLEN=128) [ SqlFieldName = parent_obj_name ];

Parent Object name Object name of the parent_obj.

• property schema as %String(MAXLEN=128);

Name of the schema the column resides in

• property status as %Integer;

The type of constraint: 0x0040 = a referential constraint 0x0080 = a check constraint

• property tableid as %Integer;

ID of the table on which the constraint is declared

• index (IDKEYIndex on tableid,constrid) [IdKey,Unique];


[BASEXML] > [%TSQL] > [sys] > [constraints]		Private Storage