How to get all index columns via query? (DBMR3196)
From DBMaker 5.4.3, we add a stored procedure command “showindex”. Enter below command, you can get the index column.
dmSQL> call showindex(owner_name, table_name);
Here is an example. There is a table t1 in database. Enter stored procedure command “call showindex”, you can get all index columns.
dmSQL> call showindex(‘sysadm’, ‘t1’);
TABLE_OWNER TABLE_NAME NON_UNIQUE INDEX_NAME TYPE ORDINAL_POSITOIN
=========== ========== ========== ========== ==== ================
SYSADM T1 0 PRIMARY* 3 1
SYSADM T1 1 IDX1 3 1
SYSADM T1 1 IDX2 3 1
SYSADM T1 1 IDX3 3 1
SYSADM T1 1 IDX3 3 2
COLUMN_NAME ASC_OR_DESC CARDINALITY PAGES FILTER_CONDITION FOREIGN_KEY
=========== =========== =========== ===== ================ ===========
ID A NULL -1 NULL 0
ID A NULL -1 id > 2 0
NAME A NULL -1 name like '%* 0
ID A NULL -1 id < 3 and n* 0
NAME A NULL -1 id < 3 and n* 0
Version: DBMaker 5.4.3
Product: Normal/Bundle
Platform: Windows/Linux