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