/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 vote122 views1 answer
Mysqli connect
SQL
1 vote135 views1 answer
Postgres count string length
SQL
2 votes144 views1 answer
Grant revoke privileges to mysql username
SQL
5 votes140 views4 answers
Upload database mysql command line
SQL
0 vote173 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote115 views1 answer
What is int in mysql
SQL
0 vote186 views1 answer
Show mysql account privilleges
SQL
0 vote140 views1 answer
Install sql server windows 10
SQL
1 vote133 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
-1 vote133 views1 answer
Auto increment psql not primary key
SQL