Thursday, April 16, 2015

Query to find the Contraints on table

select c.index_name, c.column_name
from
user_indexes i,
user_ind_columns c
where
i.index_name = c.index_name
and i.table_name = c.table_name
and i.table_name = upper('mtl_system_items_b');

No comments:

Post a Comment