In this article we will learn the trick to Move a Table from One Schema to Another Schema. Sometimes accidentally we might have given the incorrect name of a schema for the table while creating. But we can move the newly created table from one schema to another schema.
ALTER SCHEMA NewSchemaName TRANSFER OldSchemaName.TableName;
ALTER SCHEMA Details TRANSFER EmpDetails.Employees
Here Details is my New Schema Name for the table Employees and EmpDetails is the Old Schema Name, once we executed the T-SQL Statement, Details is the Schema for the table Employee.
Thus we can change the table from One Schema to Another Schema, I hope you all found this tip much useful and easy. Please share your feedback in the comment section.