title: How do I change DB schema from dbo to another schema?
body: <p>I created a new view that have a lot of joins between multiple tables , under SQL Server 2012 Management.</p>
  
  <p>The view was created under the name <code>dbo.vw_clientsTransactions</code> . </p>
  
  <p>How can I change the DB schema from <code>dbo.vw_clientsTransactions</code> , to <code>CL.vw_clientsTransactions</code> ? </p>
  
  <p>Thanks</p>