Add NOT NULL to a column in SQL

2018-06-27 06:58:23

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?

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.

链接地址: http://www.djcxy.com/p/76296.html