I want change schema name on Table.
I tried as below
ALTER SCHEMA HWData TRANSFER dbo.DesktopSoft_Master;
Msg 15530, Level 16, State 1, Line 1
The object with name "DesktopSoft_Master" already exists.
Can you give me script for change new schema Object.