Work with SQL Scripts

From the Script tab or the SQL Script page that displays in an object editor, you can view the DDL for the object you are managing. You can also send creation script to the Editor by right-clicking the object in the Object or Database Explorer and selecting Generate SQL | To Editor | Creation script.

Note: You can adjust the way a script is displayed in the Script tab. Switch on or off displaying of constraints, dependencies, script options (headers, bindings, extended properties, etc). The options that are not selected in the Script tab, won't be shown in the script. This also applies to the creation scripts that were sent to Editor using Generate SQL. Please make sure that all required options are selected in the Script tab.