Data types, primary keys, foreign keys, alternate and/or surrogate keys exist to assure data quality. Don't think a user friendly tool is useless just because it is simple.įirst of all, we have to keep in mind that database modeling and data integrity is really serious stuff. If you also believe DDs is not worthy your time, think again.
Many people didn't ever even take a look at it. In fact, DDs is available in all SQL Server editions, including SQL Server EXPRESS, the free one.ĭD is usually seen as a cosmetic feature.
It has existed on the SQL Server bundle for quite a while, and it is still there in SQL Server 2008. One of my favorites is the Database Diagram tool (which I will call DDs from now on). SQL Server has several built-in tools that are poorly used by most developers, DBAs and Database Architects. And it is not different with database models. Personally I learn a lot faster when I can visualize what I am talking about.
