Post reply

ROWGUID Question...

  • February 1, 2006 at 11:07 am

    #189067

    Can somebody tell me how do I programmatically change the RowGuid property of a column from "Yes" to "No"?

    The situation is, the client decided to change from GUIDs to IDENTITY column as primary key but still keep the GUID in case data needs to be merged. Since there's 200+ tables I don't feel like opening each table in Enterprise Manager and manually changing each RowGuid to "No".

    Thank you.

  • February 1, 2006 at 2:57 pm

    #618230

    You'd be looking for,

    ALTER TABLE myTable ALTER COLUMN myGuid

     DROP ROWGUIDCOL

     

    --------------------
    Colt 45 - the original point and click interface

  • February 1, 2006 at 3:31 pm

    #618235

    Thank you, it works!!!

    I actually tried a similar syntax before I asked the question but I was typing "DROP ROWGUID" instead and wondering why it doesn't work...

  • March 2, 2010 at 8:39 am

    #1127145

    Mark Markov (2/1/2006)

    <STRONG><FONT size=4>Thank you, it works!!!</FONT></STRONG>

    I actually tried a similar syntax before I asked the question but I was typing "DROP ROWGUID" instead and wondering why it doesn't work...

    :w00t:

    Can somebody tell me where in system tables is this property stored?

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

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