Tech Tip: How to get index types programmatically
PRODUCT: 4D | VERSION: 11.4 | PLATFORM: Mac & Win
Published On: September 10, 2009
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
The index type for a table can be obtained programmatically by querying the _USER_INDEXES table for the INDEX_TYPE field.
For example the index types for Table number 1 can be found with the following code:
After execution, the Index_type array will be populated with index type numbers with the following corresponding values:
|1||B Tree index|
|3||Cluster and Keyword Indexes|