I'm looking for a way to generate the scripts for my tables.

Right-click the table in Object Explorer, and choose Script Table As > Create To > New Query Editor Window. <img src="https://i.stack.imgur.com/9iCHa.png" alt="enter image description here"> You can also do this for multiple tables by using Object Explorer Details (F7): <img src="https://i.stack.imgur.com/QOeHt.png" alt="enter image description here"> Or right-click the database and use the Tasks > Generate Scripts wizard: <img src="https://i.stack.imgur.com/CPe8g.png" alt="enter image description here">