Hi Jay, On 12/17/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: > Hi, > > Is any possible way to know if a column is UNIQUE without "PRAGMA > index_info('<index_name>')"? Seems "PRAGMA table_info('<table_name>')" > doesn't returns the unique flag of column. > > Thanks for advice.this will show you the count of duplicated values for a column: select mycol, count(*) from mytable group by mycol
I meant, I want retrieve the information of the column or schema as much as possible, so I can build a new schema based on it. Then I need to know if column is a UNIQUE or not and so on. Such as: mycol INTEGER NOT NULL UNIQUE There is another idea, that is parse the "sql" column from "sqlite_master" table. But I'm searching for a right solution. -- Firman Wandayandi <http://firmanw.org/> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
