Other News

Editorials

Foreign Key Names

Foreign Key Names Today Thomas shares his thoughts on constraint names as well as indexes: For Foreign keys I use FK_PARENTTABLE_parentcol1_parentcol2_CHILDTABLE_childcolum1_childcolumn2 Currently, we don’t have any keys more complex than 2 columns and we are well under the 128 character limit. Our child column names are usually the same as their parent’s so I’ll probably resort to some kind of […]