On Tuesday, February 4, 2025, Rich Shepard <[email protected]> wrote:
> Should lookup tables have a numeric FK column as well as the description > column? > > If so, how should I add an FK to the two lookup tables in my database? > Most do (have a surrogate PK) since it removes cascading updates and is a smaller value. Lots of alter tables and update queries. David J.
