On 2019-10-29 6:20 a.m., Simon Slavin wrote:
• Every table must have at least one non-generated column.
I greatly admire this restriction.
From a relational purist perspective that restriction is counter-productive.
But then, disallowing a table or a key/unique constraint from having exactly
zero columns is likewise counter-productive and SQL already does that.
Allowing zero-column primary key constraints is the most elegant way to restrict
a table to having not more than 1 row, useful for storing singleton data like
some application configuration settings for example.
-- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
