OraFAQ Forum: Server Administration » Print Table Structure

Home » RDBMS Server » Server Administration » Print Table Structure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Print Table Structure [message #188600]

Sun, 20 August 2006 12:41

limbe
Messages: 20
Registered: July 2006
Location: Limbe, Cameroon

Junior Member

Hello,

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

Hugues

Report message to a moderator

Re: Print Table Structure [message #188606 is a reply to message #188600]

Sun, 20 August 2006 15:46

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic:	Space re-claimable from dba_free_space
Next Topic:	ORA-28100: policy function schema RMSDEV is invalid

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:46:51 CDT 2024