Home » RDBMS Server » Server Administration » Print Table Structure
Print Table Structure [message #188600] Sun, 20 August 2006 12:41 Go to next message
Messages: 20
Registered: July 2006
Location: Limbe, Cameroon
Junior Member

How can I print my database tables structure(Oracle 10g)

Re: Print Table Structure [message #188606 is a reply to message #188600] Sun, 20 August 2006 15:46 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure what you are looking into.
The same should work in 10g also.
scott@9i > desc dept
 Name                    Null?    Type
 ----------------------- -------- ----------------
 DEPTNO                           NUMBER
 DNAME                            VARCHAR2(14)
 LOC                              VARCHAR2(13)

If you are looking to get the "structure" programmtically
then you may need look into different views and join them
Just use dbms_metatda to extract the ddl.
Previous Topic: Space re-claimable from dba_free_space
Next Topic: ORA-28100: policy function schema RMSDEV is invalid
Goto Forum:

Current Time: Fri Jul 21 07:57:22 CDT 2017

Total time taken to generate the page: 0.12076 seconds