Only Techie
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment