Hi Nico,

not via ALTER TABLE, but if you search for the corresponding in RDB$FIELDS
and set the RDB$NULL_FLAG to 1, it's done :)

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."

----- Original Message -----
From: Nico Callewaert
To: ib-support@yahoogroups.com
Sent: Monday, December 17, 2001 3:02 PM
Subject: [ib-support] NOT NULL question


Hi list,

Is there a way to add a NOT NULL constraint to a column, with ALTER
TABLE ? (Interbase 6).

Thanks,
Nico Callewaert


[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.