The ALTER TABLE.. MODIFY COLUMN statement modifies a column on an existing table. The modification can include changing the data type and attributes. To rename at the same time, use the CHANGE COLUMN ...

Let's say you have an existing nullable column. You want to update the schema to enforce a not null constraint on that column. You can do that with an alter table DDL statement. You can do this with ...