/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 vote160 views2 answers
Full join
SQL
0 vote242 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
1 vote135 views2 answers
String to date postgres
SQL
0 vote152 views1 answer
Datagrip execute procedure
SQL
0 vote131 views1 answer
Django how to get query result count
SQL
6 votes177 views3 answers
Mysql change auto_increment start value
SQL
0 vote137 views1 answer
Mysql count grouped rows
SQL
32 votes141 views6 answers
Sql count where
SQL
2 votes150 views1 answer
Mysql select default if null
SQL
0 vote141 views1 answer
Select the date 30 days less that the todays date sql request
SQL