On Tuesday, February 4, 2025, Rich Shepard &lt;<a href="mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosys.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Should lookup tables have a numeric FK column as well as the description column?<br>
<br>
If so, how should I add an FK to the two lookup tables in my database?<br>
</blockquote><div><br></div><div>Most do (have a surrogate PK) since it removes cascading updates and is a smaller value.</div><div><br></div><div>Lots of alter tables and update queries.</div><div><br></div><div>David J.</div>