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

user_73903 0
Viewed 187146

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

sql-server-2016 sql-server-2008 schema tsql sql-server
2 Answers
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

SQL 2008: How do I change db schema to dbo

user_160760
Related