SQL · System and metadata

pragma function_list

Lists every function the SQLite build provides.

sqlRunnable example sql course

Syntax

pragma function_list

Example

Open in the lab

SELECT count(*) > 0 AS has_functions FROM pragma_function_list();

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