/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 vote108 views2 answers
Spring properties file for db
SQL
0 vote218 views1 answer
How to update random rows in sql
SQL
10 votes99 views2 answers
Django mysql
SQL
1 vote147 views1 answer
Backup mysql data only
SQL
3 votes153 views1 answer
Oracle get trigger ddl
SQL
1 vote146 views1 answer
Alter add syntax
SQL
0 vote166 views1 answer
Sql server pivot rows to columns
SQL
1 vote167 views1 answer
T-sql disable system versioning
SQL
0 vote130 views1 answer
Output to file mysql
SQL
5 votes146 views3 answers
Mysql remove unique constraint
SQL