Interview Questions - How to change the length of a column defined with a Primary key constraint?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

How to change the length of a column defined with a Primary key constraint?

Apr 23 2012 12:00AM by Manas Ranjan Dash

Question

How to change the length of a column defined with a Primary key constraint?

Answer

You can not change it directly, you have to delete and recreate with new definition.

MSDN says "To modify a PRIMARY KEY constraint, you must first delete the existing PRIMARY KEY constraint and then re-create it with the new definition"

Read More.. [107 clicks]

Published under: SQL Server Interview Questions · · · ·

Manas Ranjan Dash

39 · 5% · 1482

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"How to change the length of a column defined with a Primary key constraint?" rated 5 out of 5 by 11 readers +Manas Ranjan Dash

How to change the length of a column defined with a Primary key constraint?

Question

Answer

Your Comment