OraFAQ Forum: SQL & PL/SQL » Constraints on tables

Home » SQL & PL/SQL » SQL & PL/SQL » Constraints on tables

Tue, 14 October 2003 00:42

Hny
Messages: 1
Registered: October 2003

Junior Member

How can we see the constraints that are defined on a table?

Tue, 14 October 2003 01:42

Vishal
Messages: 86
Registered: August 2000

Member

try to find out the information you require from user_constraints

SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME FROM USER_CONSTRAINTS;

Tue, 14 October 2003 07:31

Arvind L
Messages: 27
Registered: June 2001

Junior Member

Also u can query user_cons_columns for information on constraints at a column level

HTH
Arvind

Previous Topic:	returning nextval using C
Next Topic:	Features of Oracle and RDBMS

Goto Forum:

]

Current Time: Wed Apr 24 22:49:55 CDT 2024