/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 vote244 views1 answer
Resulting Query
SQL
0 vote257 views1 answer
Sql server beginning of month
SQL
1 vote258 views1 answer
Increase existing date in sql oracle
SQL
1 vote260 views2 answers
Sql example query
SQL
2 votes220 views1 answer
Mysql admin u root p password change password
SQL
0 vote273 views1 answer
How to find symmetric pairs in sql
SQL
6 votes272 views2 answers
Non relational database
SQL
15 votes253 views4 answers
How to get all tables in sql
SQL
0 vote262 views1 answer
Mariadb select limit offset
SQL
0 vote214 views1 answer
Oracle sysdba connect as another user
SQL