SQLite Forum

Create table with column
Login
Hierarchical

Create table with column

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

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 

> 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 [link] 

See [Datatypes in SQLite](https://sqlite.org/datatype3.html), 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.