スケーラブルデータベースサーバ HiRDB Version 8 システム運用ガイド(UNIX(R)用)
SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ID FROM MASTER.SQL_TABLES WHERE N_INDEX >= 1
SELECT TABLE_SCHEMA,TABLE_NAME,INDEX_NAME,INDEX_ID,COLUMN_NAME FROM MASTER.SQL_INDEX_COLINF WHERE TABLE_SCHEMA = USER
SELECT X.TABLE_SCHEMA,X.TABLE_NAME,X.TABLE_ID, INDEX_ID,COLUMN_NAME FROM MASTER.SQL_TABLES X,MASTER.SQL_INDEX_COLINF Y WHERE X.TABLE_SCHEMA = Y.TABLE_SCHEMA AND X.TABLE_SCHEMA = USER AND X.TABLE_NAME = Y.TABLE_NAME AND N_INDEX >= 1
All Rights Reserved. Copyright (C) 2006, 2016, Hitachi, Ltd.