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

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

SQL Server

Disclaimer: I am a consultant at Amazon Web Services, and this is my personal blog. The opinions expressed here are solely mine and do not reflect the views of Amazon Web Services (AWS). Any statements made should not be considered official endorsements or statements by AWS.

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;

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

Ankush JainSoftware Engineer

Recent Posts