New course! Every coder should learn Generative AI!
Try a free lesson+ 15
ALTER TABLE table_name
MODIFY column_name VARCHAR(100) NOT NULL;
+ 2
You can change this in your database management tool or via command line with alter table. You can only execute this, if there are not yet any null values within the regarding column. If there are, it depends on the database. Some allow to change with default value to set e.g.