How to change schema name of a table in SQL Server?

ByAnkush Jain| Last Updated On Monday, Mar 26, 2018

SQL Server

Use below script to change schema name of a table in SQL Server.

Generalized Syntax:

ALTER SCHEMA NewSchema TRANSFER CurrentSchema.TableName;

For example, if you want to change your dbo.Customers table to Config.Customers, then you can use below SQL command.

ALTER SCHEMA Config TRANSFER dbo.Customers;