Page 1 of 1

How to get primary key of the table

Posted: Fri 23 Dec 2005 06:19
by jaska45
I want to get the field names that belong to the primary key. How to do that?

Best regards,
Jaakko

Posted: Fri 23 Dec 2005 10:49
by Ikar
Use TMSMetaData to perform this operation.

Posted: Fri 23 Dec 2005 15:57
by jaska45
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

Posted: Mon 26 Dec 2005 10:49
by Ikar
Set ObjectType to otPrimaryKeys and fill TableName.