Quoth Simon Slavin <slav...@bigfraud.org>, on 2010-12-27 00:17:37 +0000: > The distinction between column constraints and table constraints is > part of the spec of SQL. Had you read the SQL spec first, you > wouldn't have started this thread. But nobody expects you to read > the SQL spec before using SQL.
Except that in the syntax diagrams there are clearly-marked divisions labeled "column-constraint" and "table-constraint", and the first few sentences of the "Column Definitions" section describe the difference in basic terms: | a CREATE TABLE includes one or more column definitions, optionally | followed by a list of table constraints. Each column definition | consists of the name of the column, optionally followed by the | declared type of the column, then one or more optional column | constraints. The terms also often link back to the syntax diagrams. So it may have come from somewhere else (I don't recall reading the SQL specification personally), but the terms are certainly repeated in the SQLite doc. (I didn't start the thread either, FWIW, in case that was the specific "you" rather than the impersonal "you".) > Simon. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
