Home » SQL & PL/SQL » SQL & PL/SQL » Constraint names are stored in which table by default?
icon5.gif  Constraint names are stored in which table by default? [message #318225] Tue, 06 May 2008 02:52 Go to next message
sandeep.yadav22
Messages: 1
Registered: April 2008
Location: Noida
Junior Member
Hi,

Just wanted to ask you guys
Constraint names are stored in which table by default?

thanks in advance

thanks
sandy
Re: Constraint names are stored in which table by default? [message #318227 is a reply to message #318225] Tue, 06 May 2008 02:55 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Constraint [b]details[/i] are stored in the various constraint data dictionary views.
SELECT table_name, comments
FROM dictionary
WHERE table_name LIKE '%CONS%'
/

The above query should give you a starting point.
Previous Topic: Challenging task !!!(query help)
Next Topic: Utl_file
Goto Forum:
  


Current Time: Sun Dec 04 16:57:46 CST 2016

Total time taken to generate the page: 0.07697 seconds