- Right-click on the database and go to Tasks > Generate Scripts.
- Select the tables that you want to generate the script.
- Go to Set scripting options tab and click on the Advanced button.
- In the General category, go to Type of data to script
- There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK.
