Subject | Re: |
---|---|
Author | |
Post date | 2017-08-24T21:30:32Z |
---In firebird-support@yahoogroups.com, <jorge.brugger@...> wrote :
> It´s "fixable"?
> I have this table:>
> CREATE TABLE TRAZABILIDAD_ERRORES (
> CODIGO_ERROR SMALLINT,
> DESCRIPCION_ERROR VARCHAR(400),
> TIPO_ERROR SMALLINT
> );
>> When I try to add a PK:
> ALTER TABLE TRAZABILIDAD_ERRORES
> ADD CONSTRAINT PK_TRAZABILIDAD_ERRORES
> PRIMARY KEY (CODIGO_ERROR);
>> I get:
> unsuccessful metadata update.
> ALTER TABLE TRAZABILIDAD_ERRORES failed.> unknown ISC error 336068731.
This is:
Column: @1 not defined as NOT NULL - cannot be used in PRIMARY KEY constraint definition
Looks like you have wrong Firebird client\message file
Sure. PK columns must be defined as NOT NULL
Regards,
Vlad