Generating Changes to the Database
If you created a database diagram, you can right-click the object or objects on the diagram to generate DDL to create, replace, or alter those objects. From the context menu, select Synchronize with Database > Generate To > SQL Script. This invokes a wizard where you specify the object, operations, and SQL script options that you want to use. When you complete the wizard, the script that it generates opens in the editor, where you can run it.