jeudi 21 avril 2016

What is the sqlite default column type?

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.

Aucun commentaire:

Enregistrer un commentaire