/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 change date format
SQL
1 vote230 views2 answers
This month mysql where
SQL
7 votes218 views3 answers
Sql server reset auto increment
SQL
0 vote214 views1 answer
Sql select max value for each group
SQL
1 vote211 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
8 votes220 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote227 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
1 vote220 views1 answer
How to fetch alternate records from two tables
SQL
0 vote218 views1 answer
Oracle query to find schema you are working on
SQL
0 vote209 views1 answer
Normalization in database 2nd normal form
SQL