Difference between revisions of "Plsql search constraints"
From John Freier
(Created page with 'Run the query below to search for information on constraints. select * from all_constraints where 1=1 --and owner = 'OWNER' and constraint_name LIKE '%FK_NAME%';') |
|||
| Line 1: | Line 1: | ||
Run the query below to search for information on constraints. | Run the query below to search for information on constraints. | ||
| + | |||
| + | * OWNER = Schema | ||
| + | * FK_NAME = Constraint name | ||
| + | |||
select * | select * | ||
from all_constraints | from all_constraints | ||
Revision as of 12:56, 17 December 2012
Run the query below to search for information on constraints.
- OWNER = Schema
- FK_NAME = Constraint name
select * from all_constraints where 1=1 --and owner = 'OWNER' and constraint_name LIKE '%FK_NAME%';
