LiveCode Forums.

Posted: **Tue Jul 14, 2009 6:19 pm**

Anyone know of a way to get the name of the primary key of an SQLite table? I see a function that lists the type of each field but doesn't look like it includes the primary key property. Maybe there's an SQLite command rather than a Revolution one?
Thanks,
Pete

Posted: **Tue Jul 14, 2009 9:53 pm**

You'll have to use an SQL query: see http://www.sqlite.org/faq.html#q7

Jan Schenkel.

Posted: **Tue Jul 14, 2009 10:15 pm**

Thanks, will look into that.
Pete

LiveCode Forums.

SQLite Primary Key

SQLite Primary Key