CoderJony
CoderJony
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;
