On Fri, 15 Apr 2016 14:13:12 +0200 Cecil Westerhof <cldwesterhof at gmail.com> wrote:
> 2016-04-15 1:19 GMT+02:00 J Decker <d3ck0r at gmail.com>: > > > I would total expect any column I created without NOT NULL (double > > negative) to allow NULL whether INDEX or UNIQUE or PRIMARY is > > applied additionally....what database does otherwise? MSSQL? > > > > ?Every database that is not SQLite, because it is the standard.? Last I checked, Microsoft SQL Server raised an error if you declared a table to have a primary key with a NULL column. Whether NULL or NOT NULL was the default depended on database and connection options, but if the effect was to use a NULL column in a primary key, it failed. I stopped worrying about the default a long time ago. I figure every time I type NOT NULL, an angel gets its wings. --jkl