SQLite supports five storage classes:
SQLite uses dynamic typing - columns can store any type of data regardless of declared type. However, it's good practice to declare appropriate types for clarity.
CREATE TABLE users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER,
salary REAL,
profile_picture BLOB
);