/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

4 votes294 views1 answer
Data types in sql
SQL
1 vote279 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote301 views1 answer
Neo4j command to run script file
SQL
1 vote278 views1 answer
Rename table column name in mysql
SQL
1 vote291 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote276 views1 answer
Sql alter table order by
SQL
0 vote281 views1 answer
Monthly Birthday SQL Query
SQL
0 vote305 views1 answer
Get primary key of table
SQL
2 votes273 views3 answers
Mysql list tables by size
SQL
0 vote270 views1 answer
How to install mysql without admin rights
SQL