Can I drop a NOT NUL constrain on an existing table?
Started by stanabout 6 years ago2 messagesgeneral
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?
Alter table mytable drop constraint name_of_constraint
https://www.postgresql.org/docs/current/sql-altertable.html
On Thu, Jan 16, 2020 at 9:43 AM stan <stanb@panix.com> wrote:
Show quoted text
I see how to do this if it is a "dcleared" constraint, but this was just
defined in the table createion as inLreport_no varchar UNIQUE ,
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin