ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName
Example : 1
ALTER SCHEMA dbo TRANSFER Archive.TableName
Example : 2
change schema from dbo to rpt
Source table : dbo.rpt.TableName ( Invalid table name with additional dot)
Step 1 : Rename table with _ under score.
dbo.rpt_TableName
Step 2 : Change schema to rpt
ALTER SCHEMA rpt TRANSFER dbo.rpt_TableName
Now table name with fully qualified name rpt.rpt_TableName
Step 3 : Rename table with correct name ( to remove rpt_ )
rpt.TableName
Example : 1
ALTER SCHEMA dbo TRANSFER Archive.TableName
Example : 2
change schema from dbo to rpt
Source table : dbo.rpt.TableName ( Invalid table name with additional dot)
Step 1 : Rename table with _ under score.
dbo.rpt_TableName
Step 2 : Change schema to rpt
ALTER SCHEMA rpt TRANSFER dbo.rpt_TableName
Now table name with fully qualified name rpt.rpt_TableName
Step 3 : Rename table with correct name ( to remove rpt_ )
rpt.TableName