MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.7.39


drop table if exists notnull_tbl1;
CREATE TABLE notnull_tbl1 (c0 int, c1 int, PRIMARY KEY (c0, c1));
ALTER TABLE  notnull_tbl1 DROP c1;

Records: 0  Duplicates: 0  Warnings: 0


SELECT 
COL.COLUMN_NAME, 
COL.DATA_TYPE, 
COL.CHARACTER_MAXIMUM_LENGTH, 
COL.IS_NULLABLE 
FROM INFORMATION_SCHEMA.COLUMNS COL 
WHERE COL.TABLE_NAME = 'notnull_tbl1';


COLUMN_NAME
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
IS_NULLABLE


c0
int
null
NO