>>I have a database with UID pks which are also designated as ROWGUID=yes
>>
>>In poking around in SSMS it seems that the only place this shows up is in the Key properties, where ROWGUID for the key can be flipped to NO.
>>
>>But I need to do this programmatically in a script. I can successfully blow away the pk and that seems to blow away the index and the key as well as the column pk designation but my SMO tool is still complaining that after I strip it all clean it cannot create a new index on that column as it is a ROWGUID.
>>
>>I am a little fuzzy about where the ROWGUID designation is stored. If i do a script to on the key or index I don't see anything different from those that are not designated as Rowguid. I understand in creating the table in code how to turn it on ( off by default of course ) but I don't see anyplace to turn it off without manually doing it to the key in SSMS.
>>
>>Thoughts?
>
>AFAIK RowGuid sets the default value for the field to be NewID()

My problem here is not the default value. I have a pk that is a UID. The ROWGUID property of the key is set to YES. I can change it manually to NO but I want to do it in TSQL.

I have found that if I drop the PK entirely so that neither the key or the index or the column flag are showing anymore I still cannot create a new PK on that column with SMO as it still sees it as a rowguid.

I thought blowing away the key would do it, since that was where the rowguid property was found, but it seems there is something else going on. I looked for a table property to reset but saw nothing there either.