/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 vote116 views1 answer
Mysql delete from where like
SQL
4 votes97 views1 answer
Id primary key auto generated
SQL
0 vote111 views1 answer
Check if database exists sql
SQL
0 vote139 views1 answer
Run docker container with database as rds metabase
SQL
0 vote108 views1 answer
Get first 3 letter of department name in sql
SQL
5 votes103 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote118 views1 answer
Mysql enter ubuntu
SQL
0 vote145 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote109 views1 answer
Initcap in mysql
SQL
0 vote102 views1 answer
Mysql multiple group by
SQL