OraFAQ Forum: SQL & PL/SQL » How can I get the DDL of a table

Home » SQL & PL/SQL » SQL & PL/SQL » How can I get the DDL of a table

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

How can I get the DDL of a table [message #19006]

Mon, 25 February 2002 13:13

Kampo
Messages: 2
Registered: February 2002

Junior Member

I pretty sure when we create the table, those DDL will be stored, for example, create table temp .....
and this statement will be stored in Oracle somewhere.

but later on, I want to see how those table created. so is there any way to retrieve the DDL?

Report message to a moderator

Re: How can I get the DDL of a table [message #19017 is a reply to message #19006]

Tue, 26 February 2002 02:56

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

"create table ..." statementb is never stored by oracle.but it store necessary information about the table.

see user_tables and user_tab_columns for such information

Report message to a moderator

Previous Topic:	synonims and index
Next Topic:	no matching unique or primary key for this column-list

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:54:50 CDT 2024