you can also use the statement -- select * from all_constraints where table_name ='EMP'; to view the constraints available from other Owners/Users also.
Type: Posts; User: vikram.magoo; Keyword(s):
you can also use the statement -- select * from all_constraints where table_name ='EMP'; to view the constraints available from other Owners/Users also.
SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME='EMP';
(This will list you all the constraints from that particular user in which you are logged in.)
WHERE AS you can also use the following...