<div id="readability-page-1" class="page"><div><div><p><a rel="noopener" href="/@sindepal?source=post_page-----f789a38c2b02--------------------------------"><img alt="신상훈" src="https://miro.medium.com/fit/c/56/56/0*IyUJXQViJJEmVWaW.jpg" width="28" height="28"></a></p></div><div><p id="5d41">MariaDB 테이블 명세서 SQL</p><pre><span id="bd91">SELECT a.TABLE_NAME       '테이블명',<br>       b.ORDINAL_POSITION '순번',<br>       b.COLUMN_NAME      '필드명',<br>       b.COLUMN_COMMENT   '필드설명',<br>       b.DATA_TYPE        'DATA TYPE',<br>       b.COLUMN_TYPE      '데이터길이',<br>       b.COLUMN_KEY       'KEY',<br>       b.IS_NULLABLE      'NULL값여부',<br>       b.EXTRA            '자동여부',<br>       b.COLUMN_DEFAULT   '디폴트값'<p>FROM information_schema.TABLES a<br>         JOIN information_schema.COLUMNS b ON a.TABLE_NAME = b.TABLE_NAME AND a.TABLE_SCHEMA = b.TABLE_SCHEMA<br>WHERE a.TABLE_SCHEMA = '스키마명'<br>AND a.TABLE_NAME like '테이블명' -- 전체 조회할경우 주석 처리 <br>ORDER BY a.TABLE_NAME, b.ORDINAL_POSITION;</p></span></pre></div></div></div>

Stories by 신상훈 on Medium

MariaDB 테이블 명세서 SQL
SELECT a.TABLE_NAME       '테이블명',
       b.ORDINAL_POSITION '순번',
       b.COLUMN_NAME      '필드명',
       b.COLUMN_COMMENT   '필드설명',
       b.DATA_TYPE        'DATA TYPE',
       b.COLUMN_TYPE      '데이터길이',
       b.COLUMN_KEY       'KEY',
       b.IS_NULLABLE      'NULL값여부',
       b.EXTRA            '자동여부',
       b.COLUMN_DEFAULT   '디폴트값'
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 = '스키마명'
AND a.TABLE_NAME like '테이블명' -- 전체 조회할경우 주석 처리 
ORDER BY a.TABLE_NAME, b.ORDINAL_POSITION;

MariaDB 테이블 명세서 SQL

댓글