Hello Stephane,

> as their is not alter column .. NOT NULL can i do like this to set a
> column to be not null : UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1
> where ... ??
>

Download a copy of Database Workbench (Lite Edition comes free!) and do it
visually, you'll get a warning about
NULL values and it generates the proper script for you, that should give you
the idea.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com