The ColumnNames command returns the names of the columns in a prepared SQL statement.

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

$\mathrm{db}≔\mathrm{FileTools}\left[\mathrm{JoinPath}\right]\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{ColumnNames}\left(\mathrm{stmt}\right)$

$\left[''Date''\,''USA''\,''CHN''\,''JPN''\,''DEU''\,''FRA''\,''BRA''\,''GBR''\,''ITA''\,''RUS''\,''IND''\,''CAN''\,''AUS''\,''ESP''\,''MEX''\,''KOR''\,''IDN''\,''TUR''\,''SAU''\,''ARG''\,''ZAF''\right]$

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

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

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

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

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