How do I move a table into a schema in T-SQL

Question

I want to move a table into a specific Schema using T-SQL? I am using SQL Server 2008.

Answer 1

Please see: SQL 2008: How do I change db schema to dbo

ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName;