How to write new column with check constraint to allow only values Y, N?

Question

How to write new column with check constraint to allow only values Y, N ?

You need to provide a minimal code to reproduce the problem. See more details on how to post a question at this link: https://stackoverflow.com/help/minimal-reproducible-example — Usama Abdulrehman, Jul 03 '20 at 20:30

score 2 · Accepted Answer · answered Jul 03 '20 at 20:31

2

An alter table statement should do it:

ALTER TABLE mytable
ADD newcolumn CHAR(1) NOT NULL DEFAULT 'N' CHECK (newcolumn IN ('Y', 'N'))

answered Jul 03 '20 at 20:31

Mureinik

1 Answers1