/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 vote206 views2 answers
Mysql cast to varchar
SQL
3 votes172 views1 answer
Force using index oracle
SQL
0 vote142 views1 answer
What is initial catalog in sql connection string
SQL
0 vote156 views2 answers
Timing sql queries
SQL
0 vote154 views1 answer
Select place default lat long
SQL
0 vote148 views2 answers
Database owner can't create new tables postgres
SQL
11 votes157 views2 answers
Safe mode off mysql
SQL
0 vote168 views1 answer
Rails sql query converstion
SQL
0 vote156 views1 answer
How to connect to mysql in ef 6
SQL
0 vote145 views1 answer
How to add session data into mysql database from button
SQL