(I should have said "which tables has a database"... Sorry.) 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. Maurício > Hello Mauricio, > > i do not understand your question. Perhaps you will want to rephrase it. > The table "sqlite_master" can tell you how the tables were created. See > http://www.sqlite.org/sqlite.html or http://www.sqlite.org/faq.html, and > search for "sqlite_master". > > Martin > > Mauricio wrote: >> Hi, >> >> Is there any function or sql command that >> allows me to check which tables has a table >> and what are the constraints to those >> columns? >> >> Thanks, >> Maurício >> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
