Home » SQL & PL/SQL » SQL & PL/SQL » how can i see constraints?
how can i see constraints? [message #1618] Thu, 16 May 2002 02:55 Go to next message
paritosh agrawal
Messages: 8
Registered: May 2002
Junior Member
What is the command in SQL to see the constraints of the table?
please mail me at paritosh_a@yahoo.com

Report message to a moderator

Re: how can i see constraints? [message #1622 is a reply to message #1618] Thu, 16 May 2002 07:14 Go to previous message
Phenoracle
Messages: 35
Registered: March 2001
Member
Try looking at user_constraints, dba_constraints and all_constraints

As a starting point

Have Fun
Phenom

Report message to a moderator

Previous Topic: Query difference
Next Topic: sql query problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 13:58:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.