title: Is there a way to generate a database script for all the tables and data inside our local sql express
body: <p>We have an SQL express which comes with our Visual Studio Community 2019. Now i want to generate a full database script for our tables which include:-</p>
  
  <p>1)  The data.</p>
  
  <p>2)  The tables schema. </p>
  
  <p>But i can not find such an option, the only option i got is to generate a schema-only script for single tables as follow:-</p>
  
  <p><a href="https://i.stack.imgur.com/XLhjo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XLhjo.png" alt="enter image description here"></a></p>