Something I always end up forgetting how to do is moving objects between schemas within a database, so I thought I would put together a small post to show how to do it.

Lets assume you have an object on the dbo schema called Attendances and you want to move that table to a new schema called Students.

To do that you would use the following T-SQL

ALTER SCHEMA Students 
TRANSFER [dbo].[Attendances]

As you can see below, the object has now been moved to the new schema

That is all there is to it.