SYSCONSTRDEP shows which constraints are related to which columns.
|
Column Name |
Data Type |
Description |
|---|---|---|
|
COLNAME |
CHAR(32) |
Column Name |
|
TBLNAME |
CHAR(32) |
Table Name |
|
TBLCREATOR |
CHAR(18) |
Authorization ID of the Table |
|
TBLTYPE |
CHAR |
'T' = Table, 'V' = View |
|
CCREATOR |
CHAR(18) |
Authorization ID of the Constraint |
|
CNAME |
CHAR(32) |
Constraint Name |
|
Copyright © 2014 CA.
All rights reserved.
|
|