1- Open SQL server Management Studio.
2- Right click on the DB that contains your desired table.
3- Select “Tasks => Generate Scripts…”.
4- Follow on the wizard, and choose the objects that you want to generate scripts for (Tables, Views, Stored Procedures, etc… ).
5- From the next step, click on “Advanced“, and for the node that is labeled “Types of data to script” choose “Schema and data“.
6- Save your script and smile 🙂