/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 vote305 views2 answers
Mssql show database size
SQL
0 vote336 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote310 views3 answers
Sql server import json
SQL
0 vote331 views1 answer
Psql initialization
SQL
3 votes285 views1 answer
Oracle wait
SQL
0 vote304 views1 answer
Reset keys in sql
SQL
13 votes279 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
4 votes326 views1 answer
List tables sqlite
SQL
0 vote299 views1 answer
Mysql cdn link
SQL
1 vote322 views1 answer
SQL query to get all table records count from a database
SQL