3 ms·
> I start to question why the pictures are necessary I think I agree. My habit is to keep DDL in version control, one file per database object. If I'm interest
by SoftTalker 3y ago
> I start to question why the pictures are necessary
I think I agree. My habit is to keep DDL in version control, one file per database object. If I'm interested in a table, column, or its relationships, I can grep for names, look at the files and see the datatypes, foreign keys, etc.
I can also by grepping find any stored procedure or function that references a table or column because the code for those is in version control also.
I've tried diagrams and while they are convenient at a fairly high level they can't really show you everything and become unweildy if they try. I've found them of such limited benefit that I just work with text/code. I might make a simple diagram if I have to present/talk about a change.