/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 vote121 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
1 vote130 views1 answer
Convert epoch to date in sql server
SQL
0 vote79 views1 answer
Delete all rows from table sqlite
SQL
2 votes127 views2 answers
Run mysql command from bash
SQL
3 votes124 views1 answer
Créer une table sql
SQL
5 votes157 views3 answers
Sql limit offset
SQL
4 votes139 views3 answers
Check if two date ranges overlap sql server
SQL
21 votes136 views4 answers
Oracle add column
SQL
13 votes134 views1 answer
Sql join 3 tables on id
SQL
0 vote119 views1 answer
Get yesterday date ISO in psql
SQL