Change schema in sql server

Sql server change schema of a table

-- change schema from [dbo] to [exe]
IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'exe')) 
BEGIN
    EXEC ('CREATE SCHEMA [exe] AUTHORIZATION [dbo]')
END

ALTER SCHEMA exe 
    TRANSFER dbo.Employees

Source: stackoverflow.com

Alter schema sql server

ALTER SCHEMA exe 
    TRANSFER dbo.Employees

Source: stackoverflow.com

Alter schema sql server

IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'exe')) 
BEGIN
    EXEC ('CREATE SCHEMA [exe] AUTHORIZATION [dbo]')
END

Source: stackoverflow.com

Change schema in sql server

declare @sql varchar(8000), @table varchar(1000), @oldschema varchar(1000), @newschema   varchar(1000)

  set @oldschema = 'dbo'
  set @newschema = 'exe'

 while exists(select * from sys.tables where schema_name(schema_id) = @oldschema)

  begin
      select @table = name from sys.tables 
      where object_id in(select min(object_id) from sys.tables where  schema_name(schema_id)  = @oldschema)

    set @sql = 'alter schema ' + @newschema + ' transfer [' + @oldschema + '].' + @table

   exec(@sql)
 end

Similar codes

0 vote121 views1 answer
Mssql dockere
SQL
0 vote129 views1 answer
Select row with latest date mysql
SQL
0 vote114 views1 answer
Set a value by excuting stored procedure
SQL
1 vote128 views2 answers
Sql insert timestamp
SQL
6 votes118 views1 answer
How to count number of rows in sql
SQL
0 vote130 views1 answer
Postgres execute multiple sql file from command line
SQL
24 votes109 views4 answers
Mssql get all table names
SQL
42 votes139 views6 answers
Sql query duplicate rows
SQL
8 votes125 views3 answers
Postgresql connection string c#
SQL
2 votes117 views2 answers
Change mysql password from command line
SQL