/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

31 votes326 views3 answers
Sql count(*)
SQL
2 votes335 views1 answer
Oracle drop table free up space
SQL
1 vote347 views1 answer
Mysql show queries running
SQL
1 vote374 views1 answer
Delete mysql ubuntu 20.04
SQL
1 vote394 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote373 views1 answer
Sqlite unique multiple columns
SQL
0 vote359 views2 answers
Start mysql server using docker
SQL
-1 vote331 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote363 views1 answer
Load data infile mariadb slow
SQL
15 votes328 views4 answers
Pl sql
SQL