Search code examples
sql-servertoadcreate-tablesql-navigator

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?


Solution

  • 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.