How do I change DB schema from dbo to another schema?

Question

I created a new view that have a lot of joins between multiple tables , under SQL Server 2012 Management.

The view was created under the name dbo.vw_clientsTransactions .

How can I change the DB schema from dbo.vw_clientsTransactions , to CL.vw_clientsTransactions ?

Thanks

Answer 1

To change the schema of any object, use the following syntax:

alter schema [new_schema] transfer [old_schema].[object_name];

So, in your case, you'd do:

alter schema [CL] transfer [dbo].[vw_clientsTransactions];

Answer 2

You have to delete this view and, on Create, specify your schema in the view name!