Home Forums SQL Server 2008 T-SQL (SS2K8) how to change new schema name from existing schema - Table RE: how to change new schema name from existing schema - Table

  • You appear to have transposed the schemas

    The correct syntax is

    ALTER SCHEMA the destination schema TRASFER Object::current schema.TableName;

    so, using your case:ALTER SCHEMA dbo TRANSFER HWData.DesktopSoft_Master;

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”