Changing Primary Index

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:
I need to change the datatype of a field that is part of the Primary Key of a table. Can I do this without destroying the table and rebuilding it?

Answer:
Note: This information applies to all InterBase versions.

The SQL standard supplies no syntax for altering the datatype, scale, or length of columns. The only 'standard compliant' way to alter those characteristics is to delete and recreate the field.
Since you can not delete part of a primary key, the only way to change the primary is to delete the table.

Comments:

Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.
It seems that you are from Los Angeles, US . Info/ Feedback on this	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.