The Table Foreign Keys schema returns information about the foreign key of a TABLE object by accessing the Advanced SQL Engine Data Dictionary views. It will access 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 FOREIGN KEY constraint. |
Ordinal | Int32 | Returns the position of the constraint. |