postgres not null to null

How to remove NOT NULL constraint in postgres

A NOT NULL constraint is essential tool in postgres database to ensure validation.

But sometimes, you need to remove not null and allow column to be null.

Remove NOT NULL Postgres

ALTER TABLE table_name ALTER COLUMN column_name DROP NOT NULL

Cannot truncate a table referenced in a foreign key constraint mysql error

Constraints in SQL Server