title: Take complete backup of table with index and keys in SQL Server
body: <p>I have a table (i.e. <code>tbl_test</code>) with 46 index and 42 keys.</p>
  <p>I have taken backup via this command:</p>
  <pre><code>select *  
  into tbl_test_bkp_18112019 
  from tbl_test 
  </code></pre>
  <p>But it is unable to copy index and keys in the backup table. I want to take a complete backup of the table with index and keys. Please suggest how.</p>