The following table lists the attributes reported as the result of a HELP CONSTRAINT request for a referential constraint.
| Attribute | Data Type | Nullable | Description |
|---|---|---|---|
| Name | VARCHAR (30) | No | The name of the constraint about which HELP information is being reported. |
| Type | VARCHAR(15) | No | The type of constraint. For referential constraints, the value is REFERENCE. |
| State | CHAR(12) | No | Identifies any inconsistencies in the parent-child relationship defined in the constraint. If the State Text is:
The following additional values may be returned if Batch or Soft RI are used:
|
| Index Id | SMALLINT | No | Internal identifier for the index assigned by the system, which implements unique constraints as indexes. |
| Foreign Key Columns | VARCHAR(512) | Yes | Lists the names of the foreign key columns for the constraint. The system converts each column name, including substitution characters, to its full length. If the constructed list of column names exceeds the maximum length of the Column Names field, the list is truncated after the last comma separator that can fit within the field.
|
| Parent Database Name | VARCHAR (30) | Yes | The name of the database that contains the parent table for the constraint. |
| Parent Table Name | VARCHAR (30) | Yes | The name of the table that contains the constraint. |
| Parent Index ID (except if the State is UNRESOLVED) |
SMALLINT | Yes | Identifies the parent index for the constraint. |
| Parent Key Columns | VARCHAR(512) | Yes | Lists the names of the parent key columns for the constraint. The system converts each column name, including substitution characters, to its full length. If the constructed list of column names exceeds the maximum length of the Column Names field, the list is truncated after the last comma separator that can fit within the field.
|
| Dictionary Name | VARCHAR(128) | No | The attributes shown in this section are derived from and supersede the corresponding older Name, Parent DB, and Parent Table attributes, while providing additional functionality. The older attributes are retained for compatibility with existing applications. For details on the new attributes, see the topics beginning with Object Name and Title Data in HELP Reports. |
| SQL Name | VARCHAR(644) | ||
| UEscape | VARCHAR(1) | Yes | |
| Parent DB Dictionary Name | VARCHAR(128) | No | |
| Parent DB SQL Name | VARCHAR(644) | ||
| Parent DB UEscape | VARCHAR(1) | Yes | |
| Parent Table Dictionary Name | VARCHAR(128) | No | |
| Parent Table SQL Name | VARCHAR(644) | ||
| Parent Table UEscape | VARCHAR(1) | Yes |