Thanks for the answers guys.

Steve: the direction you mention for TSQl sounds exciting, although presumably it'll be a couple of years before this comes about.

Mattias: my FK question really concerns a column on a table which is a foreign key in more than one instance. It may be a foreign key on it's own to table A and part of a combined FK to table B. Admittedly this is a slightly unusual situation, but how would the naming cope with this? (another such problematic 'exception' would be self-joins).

Paul Ibison

Paul.Ibison@btinternet.com