Hi guys,
Here's a quick one I'm creating a table using the following : ######### CREATE TABLE IF NOT EXISTS `test_table` ( `test_field` INT NOT NULL DEFAULT -1 ); ######### Note the default -1 I then do ######### PRAGMA table_info (test_table) ######### i'm getting the following >> "0","test_field","INT","99","NULL","0" I was expecting -1 instead of NULL as default value, can anyone explain me that ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users