Open SQL Server Management Studio.
1. Right-click the database (note not the table)
2. Choose Tasks > Generate Scripts
3. In the Choose Objects pane, select the table you want to script
4. In the Set Scripting Options pane, click Advanced.
5. In the Types of Data to Script option, choose Schema and Data. (If you also want indexes, etc. make sure they are also chosen)
Click your way through the remaining screens and you're done.
No comments:
Post a Comment