view constraints on table

[bubli]

how to view the constraints on the table like the indexes created etc in sql.Its urgent ..

[anijos]

Hi

You can use USER_CONSTRAINTS or ALL_CONSTRAINTS to see all the constraints peresent on a table

Try

Select * from all_constraints
where table_name = 'your_table'

The Constraint_Type column will tell you the type of constraint.


Regards,
AniJos

[Pilgrim333]

Hi,

Most tools like TOAD and PL/SQL Developer make it able for you to see it in the interface under the table.

Pilgrim.

[kingoracle]

hi you can use user_constraints to find the results from the data dict.


regards
Rahul

[bubli]

hi,i tried using the query "select * from all_constraints....",but could not find any result.Regards,bubli

[amitpatel66]

For Indixes:

 
select * from user_indexes WHERE table_name=''
 
 

For Constraints:

 
select * from user_constraints WHERE table_name=''
 
 

[debasisdas]

@bubli
try to specify the owner as well with name of the object.

[vasanthkumar14]

It doesn't work in ORACLE 11g

[vasanthkumar14]

SQL> select * from all_constraints where table_name='departments';

no rows selected

I tried to view the constraints in the built-in schema @amitpatel66