/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 vote174 views1 answer
Sqlite higher or equal
SQL
0 vote177 views1 answer
Generate sequence number in sql server
SQL
2 votes186 views2 answers
How to run postgresql in linux
SQL
0 vote194 views1 answer
Sql count total by foreign key
SQL
0 vote174 views1 answer
Tsql cmd exec script from file
SQL
1 vote164 views2 answers
Sql select only first occurrence
SQL
0 vote179 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
-1 vote180 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote214 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
6 votes166 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL