Script för att ändra schema i SQL databas.

/* Genreate schema update script for tables with specific schema name */

USE TestDB

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.tables

WHERE SCHEMA_NAME(schema_id) = @schemaName

/* Genreate schema update script for sp with specific schema name */

USE TestDB

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.procedures

WHERE SCHEMA_NAME(schema_id) = @schemaName

/* Genreate schema update script for view with specific schema name */

USE TestDV

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.views

WHERE SCHEMA_NAME(schema_id) = @schemaName