> On 11 Apr 2018, at 6:41pm, J Decker <[hidden email]> 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
Von: sqlite-users [mailto:[hidden email]] Im Auftrag von J Decker
Gesendet: Mittwoch, 11. April 2018 19:41
An: General Discussion of SQLite Database <[hidden email]>
Betreff: [EXTERNAL] [sqlite] Constraints must be defined last?
Is there something about SQL that requires constraints to follow all column definitions?