Syntax for naming foreign keys <p>Using:</p> <pre><code>ALTER TABLE dbo.Table1Name ADD FOREIGN KEY (colname) REFERENCES dbo.Table2Name (colname) </code></pre> <p>I get a foreign key with a name like: FK&#95;&#95;_colname&#95;&#95;673F4B05</p> <p>I want it to be named: FK_Tabl1Name_Table2Name, </p> <p>...so that it will be easy to read when browsing the DB structure in SSMS. I know I can go back into the GUI and do this, but I want to be able to script it.</p> <p>So What's the SQL sytnax for adding a name to the FK? Nothing I've found online seems to bother with this.</p>