how to look for constraints in a Table

[thendal]

Hi all!

I am new to oracle db.what query do i need to use if i need to know about the constraints in the table eg: whether it has a primary key etc..

to know about the table structure i placed the command

desc tablename;

it displyed all the field name and thier data types.....

Any help will be greatly appriciated

Thanks

Thendal

 

[sem]

Explore all_constraints or dba_constraints. The structure of that views is self-describing.

 

[thendal]

Thanks sem for the quick response ...

I am afraid you misunderstood my question....

For example if you were asked to explore a table which is not created by you....but you need to know what are the field names and if there is any primary key etc....


Is there any query for that..or inbuild function in oracle...

is that explore all_constraints /dba_constraints is a query or a function in oracle...i tried in the command line
it didn't work..

-

 

[THoey]

Try:

SELECT *
FROM DBA_CONSTRAINTS
WHERE OWNER = 'Name_Of_Owner_Of_Table';

Terry M. Hoey

 

[carp]

Querying on DBA_CONSTRAINTS will give you information at the table level (e.g., what is the name of the constraint, what type of constraint is it, etc). DBA_CONS_COLUMNS will give you information at the column level (e.g., which column(s) are involved with the constraint, as well as where in the column list a given column appears for composite constraints, etc).

 

[thendal]

Thanks a lot for the info...

Thendal