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?

Report message to a moderator

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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
user_cons_columns

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 27 01:12:18 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.