How can I get all the information about a table in Oracle?

Question

How can I get all the information about a table, its columns and constraints etc in Oracle? I am using

desc MY_TABLE

but that's only giving me column name, nullness and type.

Answer 1

Check this script : http://oracletipstricks.blogspot.com/2008/01/getting-table-details-with-sqlplus.html

Give details : - Column Details

• PRIMARY KEY

• INDEXES

• FOREIGN KEYS

• CONSTRAINTS

• ROWCOUNT

• Other Tables That REFER to this Table

• PARTITIONED COLUMNS

• PARTITIONS

• TRIGGERS

• DEPENDANTS

Answer 2

You can use system tables to get the information you are looking for.

Check this link

http://techonthenet.com/oracle/sys_tables/index.php

Answer 3

try the dbms_metadata package , you can find more info here

Answer 4

Use SQL Developer.