/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

2 votes348 views2 answers
Oracle no data found error code
SQL
0 vote346 views1 answer
Select even number id data from table
SQL
0 vote335 views1 answer
Write sql query to show the details start from digit
SQL
0 vote356 views1 answer
Insert or update sql query
SQL
0 vote355 views2 answers
Update all columns in one update
SQL
0 vote306 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote357 views2 answers
Timing sql queries
SQL
0 vote327 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
1 vote348 views1 answer
Python clean sql string
SQL
1 vote328 views1 answer
Primary key reset in SQL database
SQL