date 타입 컬럼 조회

SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'schema_name'
 AND DATA_TYPE IN ('date')
ORDER BY TABLE_NAME, COLUMN_NAME;

int 타입 중 width 있는 컬럼 조회

int with width will be deprecated.

SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'schema_name'
 AND DATA_TYPE IN ('tinyint', 'smallint', 'mediumint', 'int', 'bigint')
  AND COLUMN_TYPE LIKE '%(%'
ORDER BY TABLE_NAME, COLUMN_NAME;

alter

ALTER TABLE registration_code
MODIFY is_remote TINYINT NOT NULL;