Hi,

I need dba_constraints,all_constraints,user_constraints equivalent in db2...

My requirement is I need to check all the constraints from user level for particular table...

From Admin side I know the syscat.constname,but cant find out the constraints at user level.

The DB2 catalog contains all those details. You can query the catalog also by a regular user if that user has the necessary privileges to access the catalog tables/views. If you don't have those privileges, you may be able to address this via static SQL or so.

Hi,

can U please tell me what are the privileges needed to access at user level.

And please post me the query to find the constraints at user level...

Thanks in advance...