Digital Dog wrote: > > PRAGMA default_without_rowid = on > To make all tables created while the directive is in use the WITHOUT ROWID > tables. ..
> > PRAGMA enforce_not_null_on_primary_key = on > For WITHOUT ROWID tables it would be a no-op, but for rowid tables it would > restore correct behavior. Hello, just a remark about this second pragma. Enforce_not_null_on+primary_key seems obsolete to me, also for "rowid" tables, that do not have a primary key defined. Because once the first suggested pragma (default_without_rowid) is set, this rowid will be treated as a true integer primary key, including the NOT NULL property. And this also applies if a table is defined with INTEGER PRIMARY KEY as an alias for roiwid. Does that leave only the first suggestion? Thanks, E. Pasma _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
