Shaun Seckman (Firaxis) <[email protected]> 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 results and perform a string comparison against the > "name" column until I hit a match or I've finished stepping through > the record set. > > Is there a better way?
I guess you could just prepare a statement "select mycolumn from mytable;" (you don't need to actually run it). If the column doesn't exist, prepare will fail. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
