Create Table script from exisiting table using Toad

Question

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 1

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