/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

2 votes112 views1 answer
Check isolation level in mysql
SQL
1 vote132 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote105 views1 answer
Oracle list of long running queries
SQL
0 vote112 views1 answer
Sql server union if table exist
SQL
0 vote125 views1 answer
Sql ssrs
SQL
0 vote130 views1 answer
Sqlite select split string
SQL
0 vote133 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote131 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote128 views3 answers
Insert query in ci
SQL
0 vote128 views2 answers
Laravel: customize or extend notifications - database model
SQL