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%';') |
|||
| (2 intermediate revisions by the same user not shown) | |||
| 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 | ||
Latest revision as of 11:33, 3 October 2023
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%';
