SQL Server getting values for CHECK

Question

Is there a way to get the values for a CHECK Constraint

Example

CONSTRAINT TheCollumn CHECK (TheCollumn IN('One','Two','Three') )

I want to get the 'One' 'Two' 'Three' from a Query which I can then use to populate a Dropdown without having to retype the values in the dropdown list

Answer 1

I think you want a foreign key constraint and a reference table:

create table refTheColumn (
    name varchar(255) primary key
);

. . .
    constraint fk_thecolumn foreign key (theColumn) references refTheColumn(name);

Then you can populate the list with the reference table.