hello, i'm having problems disabling unique constraints and check constraints...
the syntax is
alter table table_name disable unique (column_name)
...
but i don't know how to figure out what columns are considered unique on what tables
thanks
Printable View
hello, i'm having problems disabling unique constraints and check constraints...
the syntax is
alter table table_name disable unique (column_name)
...
but i don't know how to figure out what columns are considered unique on what tables
thanks
check out
user_cons_columns.
Do a querry on USER_CONSTRAINTS, you will get the info you need.