ALTER TABLE ALTER COLUMN (PRIMARY KEY)

Question

Post reply

ALTER TABLE ALTER COLUMN (PRIMARY KEY)

eldhose_eva

Valued Member

Points: 57
More actions
April 4, 2008 at 5:08 am

#184251

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQLZ SSChampion Points: 12872 More actions · Answer 1

Errr, did you have a question?

Karl
source control for SQL Server

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 2

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning