Re: [firebird-support] There is a simple way to rename constraint that have not a name?

2015-02-01 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jan 30, 2015, at 1:40 PM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] firebird-support@yahoogroups.com wrote: There is a way to rename constraint that have not a name? UPDATE rdb$relation_constraints SET rdb$constraint_name = 'MyPrimaryKeyName' WHERE

[firebird-support] There is a simple way to rename constraint that have not a name?

2015-01-30 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
There is a way to rename constraint that have not a name? I have a database with a no name constraint primary key in many tables. I learned my lesson and I would repair to this situation. There is a simple way to assign a name to all no name constraints? Like this statement: UPDATE