At 06:54 PM 20-01-02 +0100, you wrote:

>I took the following code from IB_SQL/Browse/Source
>
>CREATE TABLE TB_ACC (
> COD_ACC VARCHAR( 5 ) NOT NULL
>, ACC_UNI FLOAT NOT NULL
>, CONSTRAINT INTEG_89
> PRIMARY KEY ( COD_ACC )
>)
>
>I don't like the name that IB gave to the constraint. I am afraid that an
>error could come out in the future for - say - a duplicated key: it could
>take a long time to understand where it come from.
>
>A name like TB_ACCDuplicatedCOD_ACCKey would be much clearer.

CREATE TABLE TB_ACC (
COD_ACC VARCHAR( 5 ) NOT NULL,
ACC_UNI FLOAT NOT NULL,
CONSTRAINT TB_ACCDuplicatedCOD_ACC PRIMARY KEY ( COD_ACC )
);

>Is there a way to change the name of the constraint ?

No, unless you update the system tables manually (not recommended).

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________