ALTER TABLE mytable
  ALTER COLUMN mycolumn
  DROP ROWGUIDCOL

>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?