title: How to generate scripts to recreate table using SQL Server Management Studio [Schema and data]?
body: <p>I have a table in a local SQL server database. I want to recreate this table in a hosted database.</p>
  
  <p>What I want to do is to have a script that when run against the hosted database, this table is recreated with all the data, etc.</p>
  
  <p>How do I create this script using SQL Server Management Studio? Thanks.</p>