Subject | newbie questions |
---|---|
Author | Duilio Foschi |
Post date | 2002-01-20T17:54:18Z |
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.
Is there a way to change the name of the constraint ?
Thank you
Duilio Foschi
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.
Is there a way to change the name of the constraint ?
Thank you
Duilio Foschi