Hi,

WARNING!!

> DELETE FROM RDB$RELATION_CONSTRAINTS
> WHERE
> (RDB$CONSTRAINT_TYPE = 'NOT NULL') AND
> (RDB$RELATION_NAME = 'TABLE_NAME') AND
> (RDB$CONSTRAINT_NAME = 'INTEG_7');

'INTEG_7' is the name of the existing constraint -- it can be named
differently!!!

Make sure to look it up first!!

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."