What if you don't specify the datatype of new column in SQLite?

user_8814996 0
Viewed 334

What if you don't specify the datatype of new column

ALTER TABLE celebs 
ADD COLUMN twitter_handle TEXT;  #what if we don't specify it's datatype TEXT?

SELECT * FROM celebs;
sqldatatypes sqlite
1 Answers

For sqlite, the type is not required. The default type affinity will be NUMERIC. See official documentation for more detail.

user_12617520
Related