Create Table script from exisiting table using Toad

15,369

Hit F4 after entering your table name -> Click on Script tab, you'll get the DDL statements.

Share:
15,369
RaceBase
Author by

RaceBase

#SOreadytohelp

Updated on June 04, 2022

Comments

  • RaceBase
    RaceBase almost 2 years

    I am new to toad and certainly db management if not my job. I am Java Developer, where I have a scenario to create tables in test environment which are exact copy of another environment from another db.

    I have access to both tables with all permissions. All I need to do is, Get an exact copy of CREATE Table structure from Dev environment table to test environment.

    Please guide me to do this.

    Db: Oracle Toad Free ware 11.x

    Note: Table data is not required. Needed only table columns and constraints etc.