Re: [sqlite] Ideal way to check whether a table has a specific column

You could try to prepare a statement like "SELECT YourColumnName FROM YourTable;" If prepare returns an error, then likely the error message will say the column doesn't exist. If no error, it does exist. Such a simple query shouldn't take long to prepare. Probably less time then to grab the

[sqlite] Ideal way to check whether a table has a specific column

Hello all, I just wanted to find out whether or not this is the most ideal method for determining if a column exists in a table. My current technique is to do execute "pragma table_info(tableName)" then step through the results and perform a string comparison against the "name"

Re: [sqlite] Ideal way to check whether a table has a specific column

Another way SELECT name, sql FROM sqlite_master WHERE type='table' and name ='yourtable name' the field sql will give you the full table structure as a string. Parse for your desired table name. No statements fail. On Tue, Nov 3, 2009 at 4:37 PM, Igor Tandetnik wrote:

Re: [sqlite] Ideal way to check whether a table has a specific column

Shaun Seckman (Firaxis) wrote: >I just wanted to find out whether or not this is the > most ideal method for determining if a column exists in a table. My > current technique is to do execute "pragma table_info(tableName)" then > step through the