How do I move a table into a schema in T-SQL
ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName;If you want to move all tables into a new schema, you can use the undocumented (and to be deprecated at some point, but unlikely!) sp_MSforeachtable stored procedure:
exec sp_MSforeachtable "ALTER SCHEMA TargetSchema TRANSFER ?"Ref.: ALTER SCHEMA
Short answer:
ALTER SCHEMA new_schema TRANSFER old_schema.table_nameI can confirm that the data in the table remains intact, which is probably quite important :)
Long answer as per MSDN docs,
ALTER SCHEMA schema_name TRANSFER [ Object | Type | XML Schema Collection ] securable_name [;]If it's a table (or anything besides a Type or XML Schema collection), you can leave out the word Object since that's the default.