Re: [sqlite] table schmea - easy way?

2004-01-12 Thread Will Leshner
David Swigger wrote: Anyone know a more direct way? You could also try using pragma table_info(tablename). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] table schmea - easy way?

2004-01-12 Thread David Swigger
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 Th