Cannot alter column because it is 'ROWGUIDCOL'

Question

After restoring a database one of my columns was changed from NULL to newid(). I tried to run

ALTER TABLE Table1 ALTER COLUMN Id uniqueidentifier NULL

script and I got 'Cannot alter column Id because it is 'ROWGUIDCOL'

Answer 1

'Cannot alter column Id because it is 'ROWGUIDCOL'

As the message says, the column has the property ROWGUIDCOL set, you would have to remove it, but carefully, the property is for replication and if you remove it, you break replication.

See

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver16

=> ROWGUIDCOL