SQL used to create a table...9i

shajju · #1 (**permalink**) 12-24-11, 04:57

Hi

Is there a way to get the exact SQL used to create a table? (reverse engg).

Regards
Shajju

Littlefoot · #2 (**permalink**) 12-24-11, 05:15

Research use of DBMS_METATADA.GET_DDL.

shajju · #3 (**permalink**) 12-25-11, 04:10

Will do.

Many thanks.

salmansyed786 · #4 (**permalink**) 01-03-12, 02:47

In Oracle9i we have the exciting new dbms_metadata utility to display DDL directly from the data dictionary. Using this powerful utility, we can punch individual objects or an entire schema.

You simply execute dbms_metadata. get_ddl.

To know how to execute the check out at Salman's Blog: How to exact SQL used to create a table in oracle (reverse Engineering)

Internet Services

Web Development

Digital Marketing

Consumer Tech