3

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.

Improve this question
1

1 Answer 1

Reset to default
3

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

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.