Home » RDBMS Server » Server Administration » Need for exact view? (Oracle 10gR2 Windows Xp)
Need for exact view? [message #483324] Sat, 20 November 2010 05:42 Go to next message
karthickbabu
Messages: 1
Registered: November 2010
Junior Member
Hi
I want to know the name of the columns to which the constraints are created. In user_constraints it will display only the constraint name,type,tablename,Owner name e.t.c. Can anyone tell the exact view to check for the column names?
Re: Need for exact view? [message #483325 is a reply to message #483324] Sat, 20 November 2010 05:45 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user_cons_columns

Regards
Michel
Previous Topic: which document contains further information about CKPT
Next Topic: How to get hardware information from database level
Goto Forum:
  


Current Time: Sat May 11 13:46:22 CDT 2024