Adding a non-nullable TEXT field

[jda]

Hi,

I’m using this code to add a TEXT field to an existing table

     ALTER TABLE table1 ADD newField text DEFAULT '' NOT NULL

However, the field that is edited is nullable. How do I add a non-nullable field?

Thanks,

Jon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140813/f5538c26/attachment.html>