/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 vote256 views1 answer
Loading local data is disabled mysql
SQL
0 vote249 views1 answer
Pl sql search saurce code
SQL
1 vote260 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote296 views1 answer
Last 24 HOUR data in mysql
SQL
4 votes250 views2 answers
Tables in sql
SQL
3 votes331 views1 answer
Mysql cli connect with password
SQL
1 vote283 views1 answer
Create new index takes long time postgresql
SQL
2 votes287 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote287 views3 answers
Run sql command line
SQL
3 votes269 views2 answers
Sql end of month
SQL