Tuesday, February 11, 2014

oracle: find table name by constraint name

select constraint_name, owner, table_name, constraint_type from all_constraints
   where constraint_name = 'FK_DSP_FLT_04'
   and owner like 'MDM_DEV2';

No comments:

Post a Comment