"Mauricio" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Suppose I've created a table with > > create table mytable (id unique, somethingelse) > > Is it possible somehow to check after reopening > the database that mytable 'id' column was created > with the 'unique' constraint? I want to use that > to check if an existing database was properly > initialized.
select sql from sqlite_master where type='table' and name='mytable'; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
