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 d开发者_StackOverflow中文版one 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.
From SQL Server Management Studio, pick your database in Object Explorer and right-click, then Tasks > Generate Scripts
and follow the wizard:
精彩评论