Subject Re: [firebird-support] How alter column to be NOT NULL
Author Martijn Tonies
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

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

Database questions? Check the forum: