/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 vote368 views1 answer
Create new table from old table
SQL
0 vote361 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote322 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote377 views1 answer
Mysql create index lost connection
SQL
3 votes318 views2 answers
Funktion LOWER/UPPER sql
SQL
2 votes322 views2 answers
Mysql on duplicate key ignore
SQL
2 votes321 views1 answer
How to add where command in update comand with joins
SQL
0 vote330 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
27 votes355 views3 answers
Mysql show tables in database
SQL
0 vote338 views1 answer
How to add timestamp column in mysql
SQL