/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

11 votes140 views6 answers
Distinct sql
SQL
1 vote156 views1 answer
Psql connect to another database
SQL
0 vote139 views1 answer
Mysql subdate
SQL
6 votes231 views3 answers
Psql show columns of table
SQL
0 vote146 views1 answer
How to drop a trigger in postgresql
SQL
1 vote145 views1 answer
Count mysql server db tables
SQL
0 vote145 views1 answer
Delete ids between sql
SQL
5 votes153 views4 answers
Traduction
SQL
4 votes145 views2 answers
Oracle sql group by date year
SQL
0 vote177 views1 answer
Grouping by email domain mysql
SQL