/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 vote261 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote237 views1 answer
Two inner joins sql
SQL
0 vote234 views1 answer
Insufficient memory to excute the sql query
SQL
3 votes233 views2 answers
Oracle synonym
SQL
0 vote251 views2 answers
How to take recent row without limit in mysql
SQL
4 votes251 views2 answers
Installing sql on ubuntu
SQL
3 votes250 views2 answers
Oracle privileges users
SQL
7 votes232 views2 answers
Mysql db size
SQL
0 vote280 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote222 views1 answer
Take sql dump in to file
SQL