select column_name,data_type from information_schema.columns where table_name = 'STUDENT' ALTER TABLE STUDENT ALTER COLUMN SSEX CHAR(40) null