MariaDB 테이블 정의서(Layout) 출력 SQL

MariaDB table layout

 

 

 

테이블 정의서 (Table Layout)

 

 

 

SELECT
     A.TABLE_NAME AS '테이블명',
     A.TABLE_COMMENT AS '테이블 코멘트',
     B.ORDINAL_POSITION AS '순번',
     B.COLUMN_NAME AS '필드명',
     B.DATA_TYPE AS 'DATA TYPE',
     B.COLUMN_TYPE AS '데이터길이',
     B.COLUMN_KEY AS 'KEY',
     B.IS_NULLABLE AS 'NULL값여부',
     B.EXTRA AS '자동순번',
     B.COLUMN_DEFAULT AS '기본값',
     B.COLUMN_COMMENT AS '필드 코멘트'
FROM INFORMATION_SCHEMA.TABLES A
     JOIN INFORMATION_SCHEMA.COLUMNS B ON A.TABLE_NAME = B.TABLE_NAME
          AND A.TABLE_SCHEMA = B.TABLE_SCHEMA
WHERE A.TABLE_SCHEMA = 'DB 계정명' -- ☜ 수정할것
     AND A.TABLE_NAME IN ( '테이블명1', '테이블명2', ..., '테이블명n') -- ☜ 수정할것
ORDER BY A.TABLE_NAME, B.ORDINAL_POSITION;

 

 

 

테이블 정의서 샘플