Entity Table Constraints Schema

.NET CORE This feature is not supported by the .NET Core implementation of the Data Provider.

The Table Constraints schema returns information about constraints on a TABLE object by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.INDICES[V] or DBC.INDICES[V]X AND DBC.All_RI_PARENTS[V] or DBC.All_RI_PARENTS[V]X Data Dictionary view based on UseXViews Connection setting.

Column Name	Data Type	Description
Id	String	Returns a unique Id for the constraint.
Name	String	Returns the name of the constraint.
ConstraintType	String	Returns the constraint type: PRIMARY KEY UNIQUE FOREIGN KEY
IsDeferrable	Boolean	This field is always set to False.
IsInitiallyDeferred	Boolean	This field is always set to False.