Mega Code Archive

 

Categories / Delphi / ADO Database

 

Changing primary index

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.