/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

1 vote320 views1 answer
Postgresql transaction discard all
SQL
0 vote341 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote335 views1 answer
Sql contains numeric characters
SQL
0 vote326 views2 answers
How to create a table from another table in sql derby
SQL
0 vote355 views1 answer
Postgres list users and roles
SQL
0 vote312 views1 answer
Truncate table sql server foreign key
SQL
0 vote327 views1 answer
Window function to forward fill
SQL
18 votes319 views6 answers
Mysql create table
SQL
0 vote312 views1 answer
Mysql select last 15 minutes
SQL
1 vote343 views1 answer
Incompatible sql_mode=only_full_group_by
SQL