Hi all, Have a look at the following short sqlite shell session:
SQLite version 3.6.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table foo (a text(5) NOT NULL); sqlite> alter table foo add column b text(5) NOT NULL; SQL error: Cannot add a NOT NULL column with default value NULL Is there a reason for this asymetric behaviour of ALTER TABLE and CREATE TABLE? Its a bit dated version, but current version has doc'ed the limitation that for ALTER TABLE still. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users