title: SQL Server : How to copy a particular table from one schema to other schema on the same db,same server
body: <p>I have <code>Employee</code> database which has two schemas, <code>dbo</code> and <code>emp_test</code>.
  I want to copy <code>dbo.employee_salary</code> and create the same table in the <code>emp_test</code> schema.</p>
  <p>I tried with SSMS -&gt; DB -&gt; Tasks -&gt; Export option but I couldn't do that. Do we have any SQL script to achieve the same? Kindly advise.</p>