> > 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]

Reply via email to