How can I set a GUID column to ROWGUID using T-SQL?
I have a source table with a primary key column that is a guid and is set as rowguid when the table was created. I want to duplicate this table using a select-into command and then perform some actions on it and then drop the original table and rename this clone to the name of the original and continue. I can use T-SQL to add the indexes and defaults back to the table but I can't figure out the syntax to set the column back to ROWGUID. Does anyone know how to do it?