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 -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
