Re: Alter table column constraint [RESOLVED]

[Rich Shepard]

On Mon, 17 Dec 2018, Ron wrote:

Melvin is saying to:
1. create a table named valid_industry,
2. populate it with the valid industries,

3. create an FK constraint on your main table's industry column to valid_industry.industry, and then

4. drop the constraint invalid_industry.

  Got it. Hadn't before considered making column check constraints into
separate tables, but now I see the value of doing this.

Thanks, all,

Rich