For tables that are not very big, you can create a script using SQL Server Management Studio that you can use to recreate the table (and the data in the table):
1. Right-click the database and choose Tasks > Generate Scripts:
2. In the Choose Objects pane, select the table you want to script
3. In the Set Scripting Options pane, click Advanced.
4. In the Types of Data to Script option, choose Schema and Data
Click ‘Next’ through the remaining screens:
…and you will get a script for recreating the table with data.
No comments:
Post a Comment