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_CONSTRAINT S 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_constraint s 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:

[code=oracle]

select * from user_indexes WHERE table_name=''

[/code]

For Constraints:

[code=oracle]

select * from user_constraint s WHERE table_name=''

[/code]

[debasisdas]

hi,i tried using the query "select * from all_constraints ....",but could not find any result.Regards, 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='dep artments';

no rows selected

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