/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 vote192 views1 answer
Postgres set default schema
SQL
0 vote198 views1 answer
Postgresql auto increment not working
SQL
1 vote226 views1 answer
OSError: mysql_config not found
SQL
0 vote193 views1 answer
Sql dmv to capture updates
SQL
0 vote188 views1 answer
Is not null postgresql
SQL
6 votes207 views3 answers
Mysql server is not starting xampp
SQL
0 vote196 views1 answer
Dbms_output sql developer
SQL
2 votes186 views1 answer
How to select first row of database sql
SQL
50 votes272 views4 answers
Sql alter type of column
SQL
0 vote196 views1 answer
Date on SQL
SQL