Re[2]: [sqlite] How to get column description from table using SQL

2006-06-29 Thread blins
Привет Kurt, Wednesday, June 28, 2006, 6:19:37 PM, you wrote: KW> blins <[EMAIL PROTECTED]> wrote: >> How to get column description from table using SQL KW> pragma table_info() KW> KW> Regards Thanks for help, but I use sqlite through ODBC+ADO and this

Re: [sqlite] How to get column description from table using SQL

2006-06-28 Thread John Stanton
blins wrote: Hi sqlite-users@sqlite.org, How to get column description from table using SQL -- А у нас как не было порядка, так и есть! С наилучшими пожеланиями, blins mailto:[EMAIL PROTECTED] Access SQLITE_MASTER.

Re: [sqlite] How to get column description from table using SQL

2006-06-28 Thread Kurt Welgehausen
blins <[EMAIL PROTECTED]> wrote: > How to get column description from table using SQL pragma table_info() Regards

Re[4]: [sqlite] How to get column description from table using SQL

2006-06-28 Thread blins
Ïðèâåò 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 '': >>CP> select sql from sqlite_master where type='table' and name='';

Re: Re[2]: [sqlite] How to get column description from table using SQL

2006-06-28 Thread C.Peachment
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 '': >CP> select sql from sqlite_master where type='table' and name=''; >I need column definition. Sqlite does not require that columns be typed so

Re[2]: [sqlite] How to get column description from table using SQL

2006-06-28 Thread blins
Ïðèâåò C.Peachment, Wednesday, June 28, 2006, 11:47:09 AM, you wrote: CP> On Wed, 28 Jun 2006 10:29:47 +0600, blins wrote: >> How to get column description from table using SQL CP> To get table definition for '': CP> select sql from sqlite_master where type='table' and name=''; I

Re: [sqlite] How to get column description from table using SQL

2006-06-27 Thread C.Peachment
On Wed, 28 Jun 2006 10:29:47 +0600, blins wrote: > How to get column description from table using SQL To get table definition for '': select sql from sqlite_master where type='table' and name='';

[sqlite] How to get column description from table using SQL

2006-06-27 Thread blins
Hi sqlite-users@sqlite.org, How to get column description from table using SQL -- А у нас как не было порядка, так и есть! С наилучшими пожеланиями, blins mailto:[EMAIL PROTECTED]