Would it be wise to include the name of the table also ( of course in an abbreviated form ) in a field name e.g. a field f of a table t might be named tf. This aquires significance when multiple tables have fields by the same name e.g. ID. I know that any SQL server ought to automatically disambiguate collided names automatically but my feat is regarding external tools e.g. I suspect the
VB DataEnvironment designer is carEless in this behalf. What have been members experiences and what is thier advice?