Name

sqlite3_column_decltype() — Get the declared type of a result column

Definition

const char* sqlite3_column_decltype(   sqlite3_stmt* stmt, int cidx );
const void* sqlite3_column_decltype16( sqlite3_stmt* stmt, int cidx );
stmt

A prepared statement.

cidx

A column index. The first column has an index of zero (0).

Returns

The defined type name for the given result column.

Description

These functions return the declared type associated with a source column. This is the type that was given in the CREATE TABLE command used to define the source table column. Returned pointers will remain valid until sqlite3_finalize() is called on the statement, or until one of these functions is called with the same column index. SQLite will take care of all memory management for the buffers returned by these functions.

Data is only available for result columns that are derived directly from a column reference. If a result column is defined as an expression or subquery, a NULL will be returned.

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.