Name

sql_trace — Dump SQL trace data

Common Usage

PRAGMA sql_trace;
PRAGMA sql_trace = switch;

Description

The sql_trace pragma dumps SQL trace results to the screen. When enabled, trace data normally passed to the sqlite3_trace() callback will be printed. SQLite must be compiled with the SQLITE_DEBUG directive for this pragma to be included.

This is an undocumented pragma.

See Also

vdbe_trace, parser_trace, vdbe_listing

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial