How to get primary key of the table

jaska45 · Post by **jaska45** » Fri 23 Dec 2005 06:19

I want to get the field names that belong to the primary key. How to do that?

Best regards,
Jaakko

Ikar · Post by **Ikar** » Fri 23 Dec 2005 10:49

Use TMSMetaData to perform this operation.

jaska45 · Post by **jaska45** » Fri 23 Dec 2005 15:57

Thank for the repy.

However I could not find any property or method in TMSMetadata that could give me the primary keys. Can you tell me the name if the property/method please?

Best regards,
Jaakkko

Ikar · Post by **Ikar** » Mon 26 Dec 2005 10:49

Set ObjectType to otPrimaryKeys and fill TableName.