Ïðèâåò C.Peachment,

Wednesday, June 28, 2006, 12:55:46 PM, you wrote:

CP> 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.


CP> Sqlite does not require that columns be typed so
CP> they can hold anything. You need to read the table
CP> definition to see what the designer expects will be
CP> stored in each column.

I develop db schema updater and I need column definition for building
update script.

Reply via email to