/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

0 vote208 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote192 views1 answer
Opensuse stop MySQL
SQL
0 vote204 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote232 views2 answers
While mysql
SQL
0 vote197 views1 answer
Sql server whoami
SQL
0 vote199 views1 answer
Select from another database
SQL
0 vote216 views1 answer
How to find database collation in postgres
SQL
0 vote263 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
17 votes226 views4 answers
Set mysql Password
SQL
8 votes241 views4 answers
Convert date to dd/mm/yyyy sql
SQL