Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Generate Script

Home
Forums
SQL

Generate Script

krishna kanhaiya

9yAsked Nov 11, 2016, 7:01 AM1.1kSQL

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Tamil Iniyan9y ago
Hi,
Right click on the database -> task -> generate scripts
Ghulam Mujtaba9y ago
hii
i want to generate database script through sql query or c# code..
Tapan Patel9y ago
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.
Salman Beg9y ago
Hi.
Please follow this article,
https://www.mssqltips.com/sqlservertip/2500/sql-server-2008-r2-generate-scripts-wizard-with-database-schema-and-data/
thanks.