Adding a NOT NULL constraint is a common way to enforce data integrity—making sure a column can never have empty (NULL) values. Here's how to do it across major SQL databases:

General Approach #

The main command uses ALTER TABLE to modify the column's constraints. Here's the base syntax (works for PostgreSQL, Oracle, etc.):

ALTER TABLE your_table_name
ALTER COLUMN your_column_name SET NOT NULL;

Dialect-Specific Tweaks #

• MySQL/MariaDB: You need to specify the full data type when modifying the column, so use MODIFY COLUMN instead:

  ALTER TABLE your_table_name
  MODIFY COLUMN your_column_name VARCHAR(50) NOT NULL; -- Replace with your actual data type
  

  Don't skip the data type here—MySQL requires it to make the change.

• SQL Server: Similar to MySQL, include the data type in the ALTER COLUMN statement:

  ALTER TABLE your_table_name
  ALTER COLUMN your_column_name INT NOT NULL; -- Adjust data type as needed
  

Critical Pre-Check #

Before adding the constraint, make sure there are no existing NULL values in the column. If there are, the database will reject the change. Fix this first by updating those rows:

UPDATE your_table_name
SET your_column_name = 'your_default_value' -- Use a value that makes sense for your data
WHERE your_column_name IS NULL;

To switch this column from requiring a value (NOT NULL) to allowing NULLs with a default of NULL, you just need to drop the existing NOT NULL constraint. You can do this entirely via SQL without touching your database model files (like ORM definitions):

Base Syntax (PostgreSQL/Oracle) #

ALTER TABLE your_table_name
ALTER COLUMN Equipamento_Solucao_id DROP NOT NULL;

Since nullable columns already default to NULL, you don't technically need to specify DEFAULT NULL, but if you want to be explicit, you can add that:

ALTER TABLE your_table_name
ALTER COLUMN Equipamento_Solucao_id DROP NOT NULL,
ALTER COLUMN Equipamento_Solucao_id SET DEFAULT NULL;

MySQL/MariaDB Version #

Use MODIFY COLUMN to redefine the column without the NOT NULL constraint and set the default:

ALTER TABLE your_table_name
MODIFY COLUMN Equipamento_Solucao_id VARCHAR(32) DEFAULT NULL;

SQL Server Version #

In SQL Server, just set the column to NULL to remove the NOT NULL requirement:

ALTER TABLE your_table_name
ALTER COLUMN Equipamento_Solucao_id VARCHAR(32) NULL;

Again, DEFAULT NULL is implicit here, so you don't need to write it unless you're overriding a previous default value.

内容的提问来源于stack exchange，提问作者Pedro Martins