ALTERAR SCHEMA SQLSERVER
Publicado por karuta em Abril 27, 2009
– alterar SCHEMA todas SPs
SELECT ‘ALTER SCHEMA dbo TRANSFER ‘ + s.Name + ‘.’ + p.Name FROM sys.Procedures p
INNER JOIN sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = ‘dbo’
– alterar SCHEMA todas TABELAS
exec sp_MSforeachtable “ALTER SCHEMA dbo TRANSFER ? PRINT ‘? modified’ “
– alterar SCHEMA todas VIEWS
SELECT ‘ALTER SCHEMA dbo TRANSFER ‘ + s.Name + ‘.’ + p.Name FROM sys.Views p
INNER JOIN sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = ‘dbo’
