达梦导出数据库索引

发表于： 2026年4月21日 2026年4月21日
分类：达梦

SELECT 
  'CREATE ' ||
  CASE WHEN ai.UNIQUENESS = 'UNIQUE' THEN 'UNIQUE ' ELSE '' END ||
  'INDEX `' || aic.INDEX_NAME || '`' ||
  ' ON `' || aic.TABLE_NAME || '`(' ||
  LISTAGG('`' || aic.COLUMN_NAME || '`', ',') 
    WITHIN GROUP (ORDER BY aic.COLUMN_POSITION)
  || ');'
FROM ALL_IND_COLUMNS aic
JOIN ALL_INDEXES ai 
  ON aic.INDEX_NAME = ai.INDEX_NAME
 AND aic.TABLE_OWNER = ai.TABLE_OWNER
WHERE aic.TABLE_OWNER = 'WATER'
GROUP BY aic.INDEX_NAME, aic.TABLE_NAME, ai.UNIQUENESS;

SELECT

'CREATE ' ||

CASE WHEN ai.UNIQUENESS = 'UNIQUE' THEN 'UNIQUE ' ELSE '' END ||

'INDEX `' || aic.INDEX_NAME || '`' ||

' ON `' || aic.TABLE_NAME || '`(' ||

LISTAGG('`' || aic.COLUMN_NAME || '`', ',')

WITHIN GROUP (ORDER BY aic.COLUMN_POSITION)

|| ');'

FROM ALL_IND_COLUMNS aic

JOIN ALL_INDEXES ai

ON aic.INDEX_NAME = ai.INDEX_NAME

AND aic.TABLE_OWNER = ai.TABLE_OWNER

WHERE aic.TABLE_OWNER = 'WATER'

GROUP BY aic.INDEX_NAME, aic.TABLE_NAME, ai.UNIQUENESS;

zhangcunzhi

207