Sololearn: Learn to Code
New course! Every coder should learn Generative AI!
Try a free lesson
+ 15
ALTER TABLE table_name MODIFY column_name VARCHAR(100) NOT NULL;
27th Jun 2020, 9:13 AM
ÃKR
ÃKR - avatar
+ 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.
27th Jun 2020, 10:07 AM
Sandra Meyer
Sandra Meyer - avatar