/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 vote389 views1 answer
Psql check table fields
SQL
0 vote353 views1 answer
Mysql foreach insert
SQL
0 vote367 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote375 views1 answer
Mssql disable foreign key constraint
SQL
0 vote373 views1 answer
Suhaib
SQL
0 vote392 views1 answer
How to inner join 4 tables in sql
SQL
1 vote389 views1 answer
Mysql text to decimal
SQL
0 vote356 views4 answers
How to drop all tables in sql
SQL
1 vote381 views1 answer
Mysql connect bash
SQL
1 vote350 views1 answer
Sqlite check if row exists
SQL