sqlite column type

Returns the type of the nth column of the table. The first column is column 0.

Returns the type of the column with the specified name.

Returns the name and type of all the columns of table.

Warning: This property only inspects the first row of a "SELECT *" from the current table. Although the column name aspect will always be accurate, the data type may show SQLITE_NULL instead of another data type depending on whether the first row contains or does not contain null values. This is due to the fact that the SQLite API must manually inspect a single cell to obtain the SQLite data type. The creator of the table may not have inserted any values to the cell, leaving it SQLITE_NULL.

Returns one of the five sqlite datat types in a string form. The five types are as follows:

• SQLITE_INTEGER
• SQLITE_FLOAT
• SQLITE_TEXT
• SQLITE_BLOB
• SQLITE_NULL

Returns True if the column type is SQLITE_BLOB.

Returns True if the column type is SQLITE_FLOAT.

Returns True if the column type is SQLITE_INTEGER.

Returns the name of the column.

Returns True if the column type is SQLITE_NULL.

Returns True if the column type is SQLITE_TEXT.

Returns the data-type of the column.

Returns the column as name: type.