Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Friday, 18 October 2013

How do we change db schema to dbo?

How do we change any database schema owner to dbo?



select * from [Production].[Location]


ALTER SCHEMA DBO TRANSFER Production.Location


select * from Location----------return rows

select * from dbo.Location------return rows

select * from [Production].[Location]-----no rows return  due to schema changed from production  to dbo