Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can I drop a NOT NUL constrain on an existing table?

Can I drop a NOT NUL constrain on an existing table?

From
stan
Date:
I see how to do this if it is a "dcleared" constraint, but this was just
defined in the table createion as inL

 report_no                   varchar UNIQUE ,


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin

Re: Can I drop a NOT NUL constrain on an existing table?

From
Justin
Date:

Alter table mytable drop constraint  name_of_constraint


On Thu, Jan 16, 2020 at 9:43 AM stan <stanb@panix.com> wrote:
I see how to do this if it is a "dcleared" constraint, but this was just
defined in the table createion as inL

 report_no                   varchar UNIQUE ,


--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin