Hello all, Lets say I have created a table like this:
CREATE TABLE mytable( id INTEGER PRIMARY KEY first text, second text, third text) How do I go about retrieving the specifics on that table at a later date? I know I can do: PRAGMA empty_result_callbacks=ON PRAGMA show_datatypes = ON Then do a callback (or use step)routine to get the types. But in either case I still have to do a select with a limit of 1 on the table. Anyone know a more direct way? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]