Re: [sqlite] Checking column constraints

"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

Re: [sqlite] Checking column constraints

(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

Re: [sqlite] Checking column constraints

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

[sqlite] Checking column constraints

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 sqlite-users@sqlite.org