Subject Re: How alter column to be NOT NULL
Author svanderclock
sick, i just buy yesterday ems sql manager :(
do you do some price or special offer on the pro version for user that use a competitor software and want to migrate to your product ?

--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:
>
> 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
>