What is the sqlite default column type?

Question

In one of our company's scripts I found a sqlite create table script that for one of the columns the data type definition is missing. What is the default value of a column type at the time of table creation?

create table x(
y, 
z int
); 

In the above simplified example y column is under question.

When I try to check the column with

pragma table_info(x)

the information for y column is missing.

Answer 1

https://www.sqlite.org/datatype3.html

3.1. Determination Of Column Affinity

3. If the declared type for a column contains the string "BLOB" or if no type is specified then the column has affinity BLOB.

So we can assume that default type is a BLOB.

Answer 2

There are no types of a column only a type affinity. In the case it's omitted, the type affinity is NUMERIC. You can read up on it here: https://www.sqlite.org/datatype3.html