Monday, January 24, 2011

Constraints of a Database table

Queries used to find the constraints are :-

a) select * from USER_CONSTRAINTS where table_name = &table_name


b) select * from all_constraints where table_name = &table_name


c) select * from all_ind_columns where table_name = &table_name

No comments:

Post a Comment