/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

57 votes304 views6 answers
Sql alter table
SQL
0 vote191 views1 answer
Connexion mysql
SQL
0 vote190 views1 answer
Ora 00001 error catch plsql
SQL
0 vote155 views1 answer
Count char in java
SQL
0 vote191 views1 answer
T-sql check if data exists
SQL
0 vote201 views1 answer
Mysql in clausule string array
SQL
0 vote192 views1 answer
How to display value of variable in mysql
SQL
13 votes188 views6 answers
Current date sql
SQL
0 vote251 views1 answer
Selecting specific day in colum sql
SQL
2 votes194 views1 answer
Oracle run_duration average
SQL