OraFAQ Forum: Server Administration » Finding constraints on tables

Home » RDBMS Server » Server Administration » Finding constraints on tables (Windows server,10.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Finding constraints on tables [message #474117]

Thu, 02 September 2010 22:10

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

Hi I want to find out the columns on which primary constraints are enabled.Which view must I use to check this.

Report message to a moderator

Re: Finding constraints on tables [message #474121 is a reply to message #474117]

Thu, 02 September 2010 22:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

join the 2 views below
DBA_CONS_COLUMNS
DBA_CONSTRAINTS

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Thu, 02 September 2010 22:19]

Report message to a moderator

Re: Finding constraints on tables [message #474141 is a reply to message #474117]

Fri, 03 September 2010 02:17

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

sekar52 wrote on Fri, 03 September 2010 05:10

Hi I want to find out the columns on which primary constraints are enabled.Which view must I use to check this.

You can find ALL views in the link I posted you in one of your previous topics.
You can also query DICTIONARY view.
Just try it.

Regards
Michel

Report message to a moderator

Previous Topic:	Error
Next Topic:	Database Startup Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 06 00:27:42 CDT 2024