CODEWITHSUNDEEP
sql-servertoadcreate-tablesql-navigator
John Bustos
John Bustos

Reputation: 19544

Generate a "Create Table" script in Toad / SQL Navigator

I know that in SQL Server Management Studio you have the ability to right click on any table and are able to select Script Table As > CREATE To and are then able to get the entire create statement for any object in your DB.

Does anyone know if there's a similar functionality in Toad / SQL Navigator?

Upvotes: 3

Views: 7411

Answers (2)

John Bustos
John Bustos

Reputation: 19544

Although @Gary's answer above works in Toad, just for the sake of completeness, I wanted to mention that in SQL Navigator, I couldn't get it working as-is and, so, managed to do it using:

Extract DDL > Code Editor > SQL Scripts

Hope this helps someone else too..

Upvotes: 2

Gary_W
Gary_W

Reputation: 10360

In Toad, select your table in the object navigator then right-click and select "Create Script".

There are various options to select that control what is included in that script too.

Upvotes: 1

Related Questions