On Mon, Jun 11, 2012 at 10:35 AM, Paul Medynski <pmedyn...@rim.com> wrote:
> Hi folks, > > I notice that the syntax diagram for 'create table' shows the > 'column-constraint' definition as requiring 'null' to always be preceded by > 'not'. I don't see any definition that supports just 'null'. However, > when using SQLite3 3.7.3 or 3.7.9, I can create a table and specify any > column as "Foo <type> null", and it works as expected allowing the column > to contain null values. > > Is the syntax diagram simply out of date, or am I doing something that > appears to work, but will bite me in the end? :) > http://www.sqlite.org/draft/lang_createtable.html "A CREATE TABLE command specifies the following attributes of the new table: - - - - - A default value or expression for each column in the table. - - - A set of SQL constraints for each table. SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints." "A table created using CREATE TABLE AS has no PRIMARY KEY and no constraints of any kind. The default value of each column is NULL." -- -- -- --Ô¿Ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users