The ColumnCount command returns number of columns in prepared statement.

$\mathrm{with}\left(\mathrm{Database}\[\mathrm{SQLite}\]\right)$

$\left[\mathrm{Attach}\,\mathrm{Bind}\,\mathrm{ClearBindings}\,\mathrm{Close}\,\mathrm{ColumnCount}\,\mathrm{ColumnNames}\,\mathrm{Execute}\,\mathrm{Fetch}\,\mathrm{FetchAll}\,\mathrm{FetchRow}\,\mathrm{Finalize}\,\mathrm{Open}\,\mathrm{Opened}\,\mathrm{Prepare}\,\mathrm{RESULT\_BUSY}\,\mathrm{RESULT\_DONE}\,\mathrm{RESULT\_ROW}\,\mathrm{Reset}\,\mathrm{Step}\right]$

$\mathrm{db}≔\mathrm{FileTools}\[\mathrm{JoinPath}\]\left(\left[\mathrm{kernelopts}\left(\'\mathrm{datadir}\'\right)\,''SQLite''\,''G20-Population.db''\right]\right)\:$

$\mathrm{connection}≔\mathrm{Open}\left(\mathrm{db}\right)\:$

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{connection}\,''SELECT\; *\; FROM\; population''\right)$

$\mathrm{stmt}≔''SQLite\; statement''\,''SELECT\; *\; FROM\; population''$

$\mathrm{ColumnCount}\left(\mathrm{stmt}\right)$

$21$

$\mathrm{FetchAll}\left(\mathrm{stmt}\right)$

$\left[\begin{array}{c}\mathrm{53\; x\; 21}\mathrm{Matrix}\\ \mathrm{Data\; Type:}\mathrm{anything}\\ \mathrm{Storage:}\mathrm{rectangular}\\ \mathrm{Order:}\mathrm{C\_order}\end{array}\right]$

$\mathrm{Finalize}\left(\mathrm{stmt}\right)\:$

$\mathrm{Close}\left(\mathrm{connection}\right)\:$

The Database[SQLite][ColumnCount] command was introduced in Maple 18.

For more information on Maple 18 changes, see Updates in Maple 18.