alter table tablename alter column colname newDataType比如:ALTER TABLE mytableALTER COLUMN mycol1 INT DEFAULT 0