SQLite Forum

Create table with column
Login

Create table with column

(1) By Andrzej on 2020-10-15 15:19:31 [link] [source]

When I try "CREATE TABLE t1(a abc, b TEXT);" is no error although abc is no valid type. Column types are not important? How make columns 32 and 64 bit integer or bolean for flags?

(2) By Stephan Beal (stephan) on 2020-10-15 15:26:38 in reply to 1 [link] [source]

is no error although abc is no valid type.

In sqlite that's a perfectly valid table definition, though perhaps not a sensible one for your purposes. See https://sqlite.org/datatype3.html for the gory details of sqlite's data type model.

(3.1) By Larry Brasfield (LarryBrasfield) on 2020-10-15 15:29:21 edited from 3.0 in reply to 1 [source]

See Datatypes in SQLite, where you will see that your first question rises from a false assumption and that your "how to" questions have different answers than you expect.