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
No comments:
Post a Comment