Home » RDBMS Server » Server Administration » How do view table constraints information (the correct way)
How do view table constraints information (the correct way) [message #447304] Sat, 13 March 2010 07:08 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://sourceforge.net/projects/schemaspy/
Re: How do view table constraints information (the correct way) [message #447322 is a reply to message #447304] Sat, 13 March 2010 09:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: How do view table constraints information (the correct way) [message #447326 is a reply to message #447304] Sat, 13 March 2010 10:32 Go to previous messageGo to next message
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.

Re: How do view table constraints information (the correct way) [message #447327 is a reply to message #447326] Sat, 13 March 2010 11:05 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Is user connection possible if temp space is 0%?
Next Topic: Encryption issue
Goto Forum:
  


Current Time: Sun Dec 04 02:56:49 CST 2016

Total time taken to generate the page: 0.12336 seconds