Nagendran
New User
Joined: 24 Jan 2007 Posts: 89 Location: USA
|
|
|
|
Hi,
Is there any inbuilt system tables or command to identify the constraints (integrity constraint) specfied on the particular field of the DB2 table?
I have tried the below commands in SPUFI and QMF but its not working,
DESCRIBE TABLE OWNERNAME.OBJNAME
regards,
Nagu |
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Nagendran wrote: |
Hi,
Is there any inbuilt system tables or command to identify the constraints (integrity constraint) specfied on the particular field of the DB2 table?
I have tried the below commands in SPUFI and QMF but its not working,
DESCRIBE TABLE OWNERNAME.OBJNAME
regards,
Nagu |
Try this
Code: |
SELECT TBNAME, CHECKNAME, CHECKCONDITION FROM SYSIBM.SYSCHECKS
WHERE TBNAME in ('abcdefgh', 'ijklmn')
ORDER BY TBNAME, CHECKNAME
FOR FETCH ONLY WITH UR;
|
|
|