Plsql search constraints - Revision history

Jfreier at 16:33, 3 October 2023

2023-10-03T16:33:03Z

Jfreier at 16:30, 3 October 2023

2023-10-03T16:30:42Z

Jfreier at 18:56, 17 December 2012

2012-12-17T18:56:16Z

Jfreier: 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%';'

2012-12-17T18:54:36Z

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%';'

New page

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%';

← Older revision		Revision as of 16:33, 3 October 2023
Line 9:		Line 9:
	--and owner = 'OWNER'		--and owner = 'OWNER'
	and constraint_name LIKE '%FK_NAME%';		and constraint_name LIKE '%FK_NAME%';
−
−
−	~~Another way~~
−	SELECT *
−	~~FROM user_constraints~~
−	~~WHERE table_name = '<your table name>'~~
−	~~AND constraint_name = '<your constraint name>';~~

← Older revision		Revision as of 16:30, 3 October 2023
Line 9:		Line 9:
	--and owner = 'OWNER'		--and owner = 'OWNER'
	and constraint_name LIKE '%FK_NAME%';		and constraint_name LIKE '%FK_NAME%';
		+
		+
		+	Another way
		+	SELECT *
		+	FROM user_constraints
		+	WHERE table_name = '<your table name>'
		+	AND constraint_name = '<your constraint name>';

@@ Line 1: / Line 1: @@
 Run the query below to search for information on constraints.
   select *
   from all_constraints