Create Table script from exisiting table using Toad

Reddy picture Reddy · Aug 20, 2012 · Viewed 15.2k times · Source

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.

Answer

Sathyajith Bhat picture Sathyajith Bhat · Aug 20, 2012

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