> On Jan 30, 2015, at 1:40 PM, Luigi Siciliano [email protected] > [firebird-support] <[email protected]> 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 >
