GetSchema and IndexColumns matamodel table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a problem with indexes and the table named IndexColumns.
I cannot find anywhere the corresponding values of the KeyType column in
IndexColumns.
Do you know if it is the same value than the ones in syscontraints view ?
Is it an enumeration ?

I try to know if the index is a primary key or a unique key or a clustered
key, ...

Thank you

Alan

Note: excuse me if my english is not really good
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with vlookup and numbers stored as text 3
Replace letter without changing total 1
MS Access Avoiding redundancy 1
How does GetSchema get foreign key constraints? 4
GetSchema( "Columns" ) results in ??? 6
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
GetSchema from multiple tables 1
GetSchema to retrieve column properties 5

Back
Top