Thanks for the reply.
Your approach determines if 'my_table' has a column that is autoincremented.
I needed a way to determine if a specific column is autoincremented. I
resorted to a regular expression match against the SQL to check if a
specific column is autoincremented.
--
Mario Gutierrez
mario.l.gutierrez @ hotmail.com
From: Kurt Welgehausen <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to determine if a column is autoincremented?
Date: Sat, 22 Oct 2005 12:49:30 -0500
select sql from sqlite_master
where type='table' and tbl_name='my_table' and sql like '%autoincrement%'
OR
select sql like '%autoincrement%'
from (select sql from sqlite_master
where type='table' and tbl_name='my_table')
Regards
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
