Add NOT NULL to a column in SQL

Question

I have the following column

 `Equipamento_Solucao_id` VARCHAR(32) NOT NULL,

I would like it to be

`Equipamento_Solucao_id` VARCHAR(32) DEFAULT NULL,

How can I do this without changing my database model, that is, with a sql query?

Which DBMS are you using? "SQL" is just a query language, not the name of a specific database product. Please add the tag for the database product you are using postgresql, oracle, db2, sql-server, ... — user330315
– user330315, Commented Apr 24, 2018 at 17:46
Not to be too pedantic, but the DBMS you are using is mysql. MySQL Workbench is the development environment you are using to interact with the DBMS. — Honeyboy Wilson
– Honeyboy Wilson, Commented Apr 24, 2018 at 20:06

Gordon Linoff · Accepted Answer · 2018-04-24 17:39:05Z

1

You would use an alter table statement. A typical method would be:

alter table t alter column Equipamento_Solucao_id VARCHAR(32) DEFAULT NULL;

You could also look through the system tables on your database, find the not-null constraint, and then drop it specifically.

answered Apr 24, 2018 at 17:39

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1