> > I've got a question, how could I get the field parameters (e.g. id is > > integer and not null) I know that there is create table statment in > > SQLITE_MASTER for each table, but I want to use sqlite in program > > language > > there is no regular exp. in so it is hard to parse this statement, I'm > > looking for something like "describe table" statement in MySql. > > > > Check out the various pragmas, particularly table_info and > show_data_types. > > Thnx, I've tried it and it works, but I also need to know if field is part of key (or primary key) and if it is unique.
S pozdravem Bronislav Klucka ----------------------------=[ pro2-soft.com ]=---------------------------- Bronislav Klucka Pro2-Soft +420 605 582 922 [EMAIL PROTECTED] * Windows & Web applications, Computer training http://pro2-soft.com --------------------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]