On Wed, 28 Jun 2006 12:40:52 +0600, blins wrote: >>> How to get column description from table using SQL
>CP> To get table definition for 'xxxx': >CP> select sql from sqlite_master where type='table' and name='xxxx'; >I need column definition. Sqlite does not require that columns be typed so they can hold anything. You need to read the table definition to see what the designer expects will be stored in each column.