Post reply

Changing a tables schema (owner)

  • June 26, 2006 at 3:23 am

    #173079

    How do you change the schema of a table in Sql Server 2005 as the old sp_changeobjectowner doesn't seem to work.

     

    Secondly why the hell did MS have to call these things schemas which makes searching for anything to do with them return a hell of a lot of useless results.

  • June 27, 2006 at 2:25 pm

    #646218

    Use Alter Schema.

    The explanation for the change is in BOL under the heading User-Schema Separation.

  • June 28, 2006 at 2:28 am

    #646302

    Ah, thank you. There I was thinking alter schema would be for changing properties of the schema.

    I see the reason for the change, and for me it is helpful. Just why did they have to give it a name that already has another meaning in terms for sql. Very anoying if you google for any problems to do with user schemas as you get lots of solutions for you table schemas

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply