/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 vote246 views1 answer
Sql server rtrim everything after character
SQL
3 votes229 views1 answer
Sql server version query
SQL
0 vote215 views1 answer
Trim sql oracle
SQL
3 votes251 views3 answers
Update con select postgresql
SQL
0 vote228 views3 answers
Find below average salary in sql
SQL
1 vote243 views2 answers
Get table column names sql laravel
SQL
0 vote191 views1 answer
Delete all rows from table sqlite
SQL
0 vote249 views1 answer
Oracle webcenter content search enginer
SQL
11 votes234 views4 answers
MYSQL LOGIN
SQL
0 vote233 views1 answer
Join creating duplicate columns sqllite
SQL