Subject | Unique key fieldnames? |
---|---|
Author | Steve Harp |
Post date | 2005-05-05T20:30:02Z |
Hi All,
Is there a IBO component method or a query I can use to get a list of
the fieldnames of a specified table which are used in primary keys or
unique indexes? For instance, if I have a table called MyTable with a
primary key field of 'ID' and a unique index on the 'Name' field, how
would I get a list (TStrings) of these two fieldnames?
Thanks,
Steve
Is there a IBO component method or a query I can use to get a list of
the fieldnames of a specified table which are used in primary keys or
unique indexes? For instance, if I have a table called MyTable with a
primary key field of 'ID' and a unique index on the 'Name' field, how
would I get a list (TStrings) of these two fieldnames?
Thanks,
Steve