/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 vote309 views1 answer
Add current timestamp in mysql
SQL
-1 vote307 views1 answer
Sql add column bit
SQL
0 vote324 views1 answer
How to select a row in sql
SQL
7 votes306 views2 answers
N highest salary in sql
SQL
1 vote333 views1 answer
Delete from inner join sql
SQL
0 vote322 views1 answer
Mysql date format unix timestamp
SQL
0 vote312 views1 answer
Mysql disable query caching
SQL
0 vote310 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote313 views1 answer
Heidisql check how much space a row
SQL
0 vote349 views1 answer
Write SQL in ruby on rails
SQL