I ivo welch Mon, Sep 1, 2008 7:56 AM # wow! the answer seems to be "pragma table_info(main);" thanks, Gabor.