/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 vote125 views2 answers
Intersect sql
SQL
1 vote110 views3 answers
Get all tables postgres
SQL
0 vote154 views1 answer
Regex mongoose
SQL
0 vote113 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote111 views1 answer
Oracle service name view
SQL
7 votes100 views2 answers
Show size database mysql
SQL
16 votes119 views1 answer
CTE statement sql server
SQL
1 vote114 views1 answer
How to fetch alternate records from two tables
SQL
0 vote104 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote114 views1 answer
Delete hangfire retries list
SQL