Ask the Expert

Script for tables created in SQL

How to get the script (SQL) for the tables created in SQL script?

    Requires Free Membership to View

    Login

You can use the DBMS_METADATA package to reverse-engineer the CREATE TABLE command for any table in the database. You can perform a query similar to the following: 
SELECT dbms_metadata.get_ddl('TABLE','EMP','SCOTT') FROM dual;
Or, you can query for all of your tables using the Data Dictionary: 
SELECT dbms_metadata.get_ddl('TABLE',table_name,USER) FROM user_tables;

This was first published in March 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top