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

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


Hugues
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: 10672
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
or
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 Dec 09 15:59:36 CST 2016

Total time taken to generate the page: 0.17829 seconds