SQL: Create a script for an existing table

SQL Management studio will script out a table for you if it already exists.

To do this, right click on the table you wish to script, select “Script Table As” and the “CREATE TO” and finally choose where to create the script.