SQL · System and metadata

typeof()

The storage class of a value: null, integer, real, text or blob. SQLite.

sqlRunnable example sql course

Syntax

typeof(expression)

Example

Open in the lab

SELECT typeof(1), typeof('a'), typeof(NULL);

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.