<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTOURBUG - Can't change Primary Key's name with Firebird Embedded db." href="https://bugs.documentfoundation.org/show_bug.cgi?id=108068#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTOURBUG - Can't change Primary Key's name with Firebird Embedded db." href="https://bugs.documentfoundation.org/show_bug.cgi?id=108068">bug 108068</a> from <a class="email" href="mailto:BridgeportContractor@gmail.com" title="Howard Johnson <BridgeportContractor@gmail.com>"> Howard Johnson</a> <pre>I had no idea, sorry for jumping up and down about this; now I will go jump up and down at the firebird team. :-) Till then, is it possible to put this up on the screen: >>To rename this field in Firebird you must either delete this field, and then re-create it with the new name, or you might want to copy it, into a new field first with the new name, and then delete the original field once this is done. >From the Firebird 2.5 documentation (<a href="https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-tbl.html">https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-tbl.html</a>): * It will not be possible to change the name of a column that is included in any constraint: PRIMARY KEY , UNIQUE key, FOREIGN KEY , column constraint or the CHECK constraint of the table. * Renaming a column will also be disallowed if the column is used in any trigger, stored procedure or view. Thanks guys!</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>