All: I've decided to take advantage of long object names and update column names like 'TDistID' to 'TaxDistrictID'.
Where these are referenced primary keys, ALTER TABLE is out because you can't rename indexed columns. Database Explorer > Design Table > Columns allows name changes for columns at each end of the FK relationship, no issue. I need to carefully plan, sequence and pre-document these changes so that I can correct column references in the various code files. Is there a way to code these key-column name changes (e.g. something like ALTER TABLE with an index override)? Thanks Bruce
