Selecting table structure and constraints

[Guest_imported]

Hi
May I know whats the query to find out column names and constraints on them, for a given table name.
Complete query will bw highly appreciated
Thanks

 

[carp]

For table columns:

SELECT column_name FROM dba_tab_columns WHERE table_name = 'MY_TABLE';

For constraints you will have to look at DBA_CONSTRAINTS and DBA_CONS_COLUMNS.

DBA_CONSTRAINTS will tell you the consraint name and what type of constraint it is.
DBA_CONS_COLUMNS will tell you the constraint name as well as which column(s) it applies to.