/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 vote199 views1 answer
Sql cmd no truncate
SQL
0 vote179 views3 answers
Sql all columns
SQL
3 votes209 views1 answer
Mysql replace string in table
SQL
0 vote188 views1 answer
Add unique constraint sql server multiple columns
SQL
3 votes197 views2 answers
How to start mysql in terminal
SQL
0 vote222 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote206 views1 answer
Dual in db2
SQL
2 votes176 views1 answer
Postgresql left join distinct on
SQL
1 vote200 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote189 views1 answer
Trigger stock phpmyadmin output message
SQL