Finding Primary Key of a table

Steve Dobb

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Finding Primary Key of a table

Is there any way to find the primary key of a table at run time? The
primary key does not show up in the IndexDefs property of a TTable.

Steve Dobbs

Garry Kerna

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Finding Primary Key of a table

Quote

Steve Dobbs wrote:

> Is there any way to find the primary key of a table at run time? The
> primary key does not show up in the IndexDefs property of a TTable.

> Steve Dobbs

Did you update the indexdefs? table.indexdefs.update

Also the primary key will be the first index in the list and will have
an empty name.

Garry Kernan

Other Threads

1. find primary key against database server table?

2. Primary key or not primary key.........

3. How to find your primary key in interface

4. 'Could not find PRIMARY KEY...

5. Find primary key

6. Primary Keys from table

7. Interbase - Can't add primary key to table

8. Get primary key of an view/table

9. Sorting Paradox Tables With Indexed Primary Key Fields

10. Sorting a PDox Table that doesn't have a primary key