[SOLVED] How to describe table structure in PL/SQL developer IDE through sql command?

fantasy1215 · 04-11-2013, 10:09 PM

As you know,PL/SQL developer is a good IDE to execute test sql command.
What is the sql command to describe the table structure, table index, primary key, foreign key?
Thanks.

kooru · 04-13-2013, 02:30 AM

Hi,

i don't use PL/SQL developer.
Anyway, for example:

Code:

select * from ALL_TAB_COLUMNS where TABLE_NAME = 'MY_TABLE' order by column_id --(to have desc)

Code:

select * from ALL_INDEXES where TABLE_NAME = 'MY_TABLE' --(to have indexes)

Code:

select * from ALL_CONSTRAINTS where TABLE_NAME = 'MY_TABLE' and CONSTRAINT_TYPE = 'P' --(to have PK)

Code:

select * from ALL_CONSTRAINTS where CONSTRAINT_TYPE='R' and R_CONSTRAINT_NAME in 
  (select CONSTRAINT_NAME
  from ALL_CONSTRAINTS
  where CONSTRAINT_TYPE in ('P','U')
  and TABLE_NAME='MY_TABLE') --(to have FK)

Regards

fantasy1215 · 04-14-2013, 08:20 PM

Thanks so much. This helps me a lot.