CODEWITHSUNDEEP
sql-server
user733957
user733957

Reputation: 45

How to dump the script from sql server?

I would like to dump a script for all the tables in the database. I guess it can be done through

database->right-click->tasks->export Data

But I don't know how exactly to do this. Please help. I am looking for a script with CREATE TABLE command.

Upvotes: 3

Views: 311

Answers (1)

marc_s
marc_s

Reputation: 755471

From SQL Server Management Studio, pick your database in Object Explorer and right-click, then Tasks > Generate Scripts and follow the wizard:

enter image description here

Upvotes: 3

Related Questions