title: How to copy data from one table to another new table in SQL Server?
body: <p>When I searched for it I got some answers. But when I am working with this solution- (screenshot attached).</p>
  
  <p><a href="https://i.stack.imgur.com/Glsi1.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Glsi1.jpg" alt="enter image description here"></a></p>
  
  <p>I am getting error </p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 38<br>
    Incorrect syntax near the keyword 'like'</p>
  </blockquote>
  
  <p>I have a table <code>student_constraint</code> and I want to create a new table like <code>student_constraint</code>.</p>
  
  <pre><code>create table student_info like student_constraint 
  </code></pre>
  
  <p>Can you please explain this concept? </p>
  
  <p>Thank you!</p>