Re: Alter table column constraint [RESOLVED]

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

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