# Create table statement

**URL:** <https://forums.toadworld.com/t/create-table-statement/10824>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 27, 2011, 6:39am UTC](https://forums.toadworld.com/t/create-table-statement/10824 "2011-10-27T06:39:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TL\_TL](https://avatars.discourse-cdn.com/v4/letter/t/9de0a6/32.png) [@TL\_TL](https://forums.toadworld.com/u/TL_TL)\
**Post date:** [October 27, 2011, 6:39am UTC](https://forums.toadworld.com/t/create-table-statement/10824/1 "2011-10-27T06:39:35Z")

</div>

Hello,  
I’m comletely new to toad.  
I want to create a table using an existing statement (I have a text file containing many “create table” statements).  
I didn’t find a sql editor where I can paste the existing statement…  
The only way I found to create a table is to add each column and constraint one by one, using the “create table” icon on top of the tables browser.

I’m using Toad for Oracle trial version.

Any help will be greated.

TL.

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [October 27, 2011, 7:30am UTC](https://forums.toadworld.com/t/create-table-statement/10824/2 "2011-10-27T07:30:59Z")

</div>

Hi Talia,

1. Press the editor button. It’s usually the first icon in the second row.

2. If the button is greyed out, then you have to make it available by doing  
this…

Go to the menu - View/Toad Options… - under Windows find ‘Editor’ and check  
‘Available’ and ‘Auto Open’ (if you want it to open automatically when you start  
Toad). [Apply].

From there you can use File/Open File to locate and load your script file or  
paste like you mentioned. To run it ‘as a script’ use F5 or press the ‘Execute  
as Script’ (lightning bolt on paper icon) button.

btw…checking out the Help (Help/Contents) might serve as a good starting point  
as well.  
 ![image001.png](https://global.discourse-cdn.com/quest/original/2X/3/3a28eb8c2b38f1c28c714b12ac02dd5dbd034f8e.png)