/SQL/Sql server change schema of a table

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

Similar codes

0 vote188 views1 answer
Install sql server windows 10
SQL
0 vote178 views1 answer
Sql server datetime to string
SQL
0 vote182 views1 answer
What is ssrs and ssis in sql server
SQL
1 vote167 views1 answer
Oracle rolling back
SQL
24 votes203 views6 answers
Alter table name sql
SQL
0 vote198 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
13 votes169 views2 answers
Sql count distinct group by
SQL
0 vote174 views1 answer
Firebase sql
SQL
0 vote163 views1 answer
Create bakupd database sqlserver
SQL
0 vote204 views1 answer
Ubuntu connect to mssql database
SQL