-4

I need a Transact-SQL script to generate the creation scripts for each object (views, tables, SP's, indexes, users) in the database. Each creation script will be saved in a .sql file. Thanks in advance.

Improve this question
2

1 Answer 1

Reset to default
2

Go to your Sql Server Management Studio

Right Click your Database from where you want to create the scripts and follow the path shown in the screen shot.

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

What I need is a script, not by clicking some options in the SQL enterprise manager
something like this: select all objects to iterate each one of them ( create a script to generate again the current object in the iteration list. then, save the script in a .sql file in the hard disk ) that's it, thanks in advance

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.