/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

15 votes290 views4 answers
T-sql drop function if exists
SQL
2 votes364 views2 answers
Python escape string for sql
SQL
2 votes313 views2 answers
How to run postgresql in linux
SQL
0 vote305 views1 answer
Postgres populate table from another table
SQL
0 vote306 views1 answer
Mysql query to select the highest value
SQL
4 votes283 views1 answer
Oracle show errors compilation
SQL
0 vote289 views1 answer
View to table
SQL
0 vote290 views2 answers
Getting customers with no orders sql
SQL
0 vote349 views1 answer
Drop view sql
SQL
0 vote278 views1 answer
Phpmyadmin mysql conflict
SQL