Create Table script from exisiting table using Toad
create-table, database, oracle, toad
Solution
Hit F4 after entering your table name -> Click on Script tab, you'll get the DDL statements.
Problem
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.