On 11/04/2018 19:45, Simon Slavin wrote:
On 11 Apr 2018, at 6:41pm, J Decker <d3c...@gmail.com> wrote:

Is there something about SQL that requires constraints to follow all column

I don't know if it applies to SQL in general, but it is in SQLite:


The table constraints come after the column definitions.

That is a SQLite restriction. According to the SQL standard,
column definitions and table constraints can appear in any order.
In fact, PostgreSQL accepts the following:

  create table T (
    constraint foo check (x > 0),
    x integer primary key


sqlite-users mailing list

Reply via email to