Answers for "postgresql change column to nullable"

SQL
3

postgresql change column to not null

-- To change a column to NOT NULL:
ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;
Posted by: Guest on November-02-2020
0

postgresql alter column nullable

-- To change a column to nullable
ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;
Posted by: Guest on February-26-2021

Code answers related to "postgresql change column to nullable"

Code answers related to "SQL"

Browse Popular Code Answers by Language