OraFAQ Forum: Server Administration » How do view table constraints information (the correct way)

Home » RDBMS Server » Server Administration » How do view table constraints information (the correct way)

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

How do view table constraints information (the correct way) [message #447304]

Sat, 13 March 2010 07:08

ziggy25
Messages: 206
Registered: July 2005

Senior Member

Hi,

I know that you can view all constraints in a table using $USER_CONSTRAINTS or $USER_INDEXES view. What i find difficult is that the information in those views is not really well presented.

I find it very hard to follow. For example, just to find out which columns are foreign keys and which tables they refer to is really tedious.

Is there a simpler way to view all the constraints especially foreign keys of a table and including which table columns they refer to in the child table.

I like to see a diagramatic representaion of all the tables involved so i like to see both the parent and the child tables, which columns are related and using which FKs etc.

Is there an easier way to view this information?

Thanks

[Updated on: Sat, 13 March 2010 07:16]

Report message to a moderator

Re: How do view table constraints information (the correct way) [message #447314 is a reply to message #447304]

Sat, 13 March 2010 08:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://sourceforge.net/projects/schemaspy/

Report message to a moderator

Re: How do view table constraints information (the correct way) [message #447322 is a reply to message #447304]

Sat, 13 March 2010 09:12

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

Senior Member
Account Moderator

You can create a view based upon the dictionary one to see the data as you want.

Regards
Michel

Report message to a moderator

Re: How do view table constraints information (the correct way) [message #447326 is a reply to message #447304]

Sat, 13 March 2010 10:32

ziggy25
Messages: 206
Registered: July 2005

Senior Member

That schemaspy is quite usefull. I will definately keep it and use it thanks.

I was more interested in solutions within the SQLPLUS domain. I am trying to write a script to do that and would list the data in table format.

Report message to a moderator

Re: How do view table constraints information (the correct way) [message #447327 is a reply to message #447326]

Sat, 13 March 2010 11:05

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

Senior Member
Account Moderator

Quote:

I am trying to write a script to do that and would list the data in table format.

Good, post it here when you'll find it.

Regards
Michel

Report message to a moderator

Previous Topic:	Is user connection possible if temp space is 0%?
Next Topic:	Encryption issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 02:35:39 CDT 2024