Finding constraints on tables [message #474117] |
Thu, 02 September 2010 22:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
Re: Finding constraints on tables [message #474141 is a reply to message #474117] |
Fri, 03 September 2010 02:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
sekar52 wrote on Fri, 03 September 2010 05:10Hi 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
|
|
|