sql server change PK type from int to uniqueidentifier
Posted
by Antonio Nakic Alfirevic
on Stack Overflow
See other posts from Stack Overflow
or by Antonio Nakic Alfirevic
Published on 2010-03-29T13:52:39Z
Indexed on
2010/03/29
14:13 UTC
Read the original article
Hit count: 511
Filed under:
sql-server
Hi! I need to change the type of my primary key column on a table from int to guid. The database already has data that I don't want to lose, and there are foreign keys to consider. Is there a painless way to do this or do I have to manually do it through a big a** script?:) I would appreciate any suggestions
© Stack Overflow or respective owner
