| Subject | Re: [firebird-support] There is a simple way to rename constraint that have not a name? |
|---|---|
| Author | Ann Harrison |
| Post date | 2015-02-01T21:52:12Z |
> On Jan 30, 2015, at 1:40 PM, Luigi Siciliano luigisic@... [firebird-support] <firebird-support@yahoogroups.com> wrote: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.
>
> 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?
>
>
Good luck,
Ann
>