Generate Script

Question

How to Generate Script With All Schema of Database through Store Procedure. Thanks in Advance.

Tamil Iniyan · Answer

Hi Right click on the database -> task -> generate scripts

Tapan Patel · Answer

Please try something below inside your stored proc code. DECLARE @schemaInfo TABLE ( name NVARCHAR(128) schemaowner NVARCHAR(128)); INSERT INTO @schemaInfo SELECT SCHEMA_NAME  SCHEMA_OWNER FROM INFORMATION_SCHEMA.SCHEMATA SELECT * FROM @schemaInfo Please mark it as an answer if it addresses the issue.

Ghulam Mujtaba · Answer

hii i want to generate database script through sql query or c# code..

Salman · Answer

Hi. Please follow this article https://www.mssqltips.com/sqlservertip/2500/sql-server-2008-r2-generate-scripts-wizard-with-database-schema-and-data/ thanks.