ALTER TABLE ALTER COLUMN (PRIMARY KEY)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » ALTER TABLE ALTER COLUMN (PRIMARY KEY)

ALTER TABLE ALTER COLUMN (PRIMARY KEY)

Rate Topic

Display Mode

Topic Options

Author

Message

eldhose_eva

Posted Friday, April 04, 2008 5:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 11, 2009 3:32 AM
Points: 1, Visits: 16

I would like to ALTER Primary Column data type to INT from NUMERIC. Foreign key relationships are there. While trying to alter it's giving error like object refers.. Is there any scripts are available for ALTER Primary Key Columns

Post #479823

SQLZ

Posted Friday, April 04, 2008 5:12 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 02, 2013 5:38 AM
Points: 870, Visits: 858

Errr, did you have a question?

Karl
source control for SQL Server

Post #479825

Grant Fritchey

Posted Friday, April 04, 2008 6:02 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:41 AM
Points: 13,383, Visits: 25,189

Nah, they were just working on their server and typed into the wrong window. I do the same thing all the time. In fact, that explains most of my posts.

w00t

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #479862

« Prev Topic | Next Topic »

Permissions