How to Generate Script of Database in SQL Server05.25.2011right click database >task> Generate scripts> Wizard> Choose what you want to script Previous: Moving a Database in SQL Server Management StudioNext: SQL Server Not Letting You Save Tables?