oracle,sql

[v varaprasad]

how to findout which columns have constriants in a table?

[rski]

In all_cons_column s you can find constraint and related with it table name and column name. If you join all_cons_column s with all_constraints (join on constraint_name ) you will also get the type of constraint (primary_key, unique_key,chec k_key, etc).
For more see here

http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_1037.htm

http://docs.oracle.com/cd/B14117_01/server.101/b10755/statviews_1035.htm