Re: [sqlite] Is Column UNIQUE? How To

2006-12-18 Thread Dennis Cote
Firman Wandayandi wrote: Hi, Is any possible way to know if a column is UNIQUE without "PRAGMA index_info('')"? Seems "PRAGMA table_info('')" doesn't returns the unique flag of column. Thanks for advice. Firman, You should try pragma index_list(''). It returns a list of all the indexes (or

Re: [sqlite] Is Column UNIQUE? How To

2006-12-16 Thread Jay Sprenkle
On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: Yeah, as I thought before. Well nevermind, I should parse the table schema then. Thanks You're welcome. -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command

Re: [sqlite] Is Column UNIQUE? How To

2006-12-16 Thread Firman Wandayandi
On 12/17/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: > 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

Re: [sqlite] Is Column UNIQUE? How To

2006-12-16 Thread Jay Sprenkle
On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: 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. select * from sqlite_master; It tells you

Re: [sqlite] Is Column UNIQUE? How To

2006-12-16 Thread Firman Wandayandi
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('')"? Seems "PRAGMA table_info('')" > doesn't returns the unique flag of column. > >

Re: [sqlite] Is Column UNIQUE? How To

2006-12-16 Thread Jay Sprenkle
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('')"? Seems "PRAGMA table_info('')" doesn't returns the unique flag of column. Thanks for advice. this will show you the count of duplicated values for a

[sqlite] Is Column UNIQUE? How To

2006-12-16 Thread Firman Wandayandi
Hi, Is any possible way to know if a column is UNIQUE without "PRAGMA index_info('')"? Seems "PRAGMA table_info('')" doesn't returns the unique flag of column. Thanks for advice. -- Firman Wandayandi