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

[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
>   rdb$relation_name = MyTable
>   AND rDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
> 
> There are contraindications?
> 
> 

Sigh.  In V3, system tables are read only except through DDL. I don't know 
whether the DDL has been extended to include renaming constraints.

Good luck,

Ann
>