테이블 정의서 쿼리

SELECT
    column_name, 
    column_comment, 
    data_type, 
    CHARACTER_MAXIMUM_LENGTH as len,
    case
    	when IS_NULLABLE = 'YES'
    	then 'Y'
    	else ''
	end as isNull,
    case
    	when COLUMN_KEY = 'PRI'
    	then 'Y'
    	else ''
	end as pk
FROM
    information_schema.columns
where table_name = '테이블명' and TABLE_SCHEMA = '스키마명';