목록인덱스정의서 (1)

뽁

MySQL.인덱스 정의서 추출 쿼리문

SELECT A.TABLE_SCHEMA "DB", A.TABLE_NAME "테이블ID", A.TABLE_COMMENT "테이블명", B.INDEX_NAME "인덱스명", B.COLUMN_NAME "컬럼ID", C.DATA_TYPE "데이터타입", CASE WHEN C.NUMERIC_SCALE IS NULL OR C.NUMERIC_SCALE = '0' THEN CASE WHEN C.NUMERIC_PRECISION IS NOT NULL THEN C.NUMERIC_PRECISION ELSE C.CHARACTER_MAXIMUM_LENGTH END ELSE CONCAT(C.NUMERIC_PRECISION, ',', C.NUMERIC_SCALE) END "데이터사이즈", CASE WHEN B.INDEX_NAME =..
IT Cafe+/MySQL 2019. 10. 1. 10:52
Prev 1 Next