Home » SQL & PL/SQL » SQL & PL/SQL » How can i get table info.?
How can i get table info.? [message #41204] Tue, 10 December 2002 02:21 Go to next message
sujit
Messages: 94
Registered: April 2002
Member
How can i get all the information about the constraints in a table and how it is ralated to other tables? is there any special script or tool for knowing the same?
Regards
Sujit

Report message to a moderator

Re: How can i get table info.? [message #41205 is a reply to message #41204] Tue, 10 December 2002 02:23 Go to previous message
Venkat
Messages: 110
Registered: February 2001
Senior Member
use tables
1.user_tables
2.user_constraints...

you'll find the information u needed

Report message to a moderator

Previous Topic: Update Creating - Rollback segment problems.
Next Topic: storing a file content in DatabaseColumn
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 17:40:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.