how to alter primary key int datatype to uniqueidentifier

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » how to alter primary key int datatype to...

how to alter primary key int datatype to uniqueidentifier

Rate Topic

Display Mode

Topic Options

Author

Message

dastagirid

Posted Tuesday, November 10, 2009 6:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 02, 2009 12:19 AM
Points: 108, Visits: 248

hi

help me..

how to alter primary key int datatype to uniqueidentifier

Thanks
Dastagiri.D

Post #816464

GSquared

Posted Tuesday, November 10, 2009 6:57 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

Drop the PK constraint.

Add the UID column, add a PK constraint to that.

Drop the old ID column.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #816469

dastagirid

Posted Tuesday, November 10, 2009 7:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 02, 2009 12:19 AM
Points: 108, Visits: 248

hi..

any code.

i need t-sql query for alter int to uniqueidentifier

Thanks
Dastagiri.D

Post #816474

GilaMonster

Posted Tuesday, November 10, 2009 7:31 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943

Look up ALTER TABLE in books online (web version: http://msdn.microsoft.com/en-us/library/ms190273%28SQL.90%29.aspx)

ALTER TABLE ... DROP CONSTRAINT ... to remove the pk
ALTER TABLE ... ADD ... to add a new column
ALTER TABLE ... DROP ... to drop the old column
ALTER TABLE ... ADD CONSTRAINT ... to replace the pk constraint.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #816518

« Prev Topic | Next Topic »

Permissions