Re: ID column naming convention

On 10/13/2015 3:27 PM, droberts wrote:
> Thanks.   My only question is how do you create a schema diagram (ERD) then?
> The tool won't know what the relationships are unless maybe you put foreign
> key constraints on.  BTW does anyone recommend a tool to to that?  I've been
> playing with DbVisualizer.


I don't know of any ERD tool that will recognize foreign key references
without FK constraint definitions, regardless of what things are named.



--
john r pierce, recycling bits in santa cruz