This is the same as the Oracle version, but works with SQL Server (tested on SqlServer 2012)
ERDCreationSqlServer-2012-populated.sql
Only problem I’ve identified is that the databases that most need a generated ERD often are lacking in foreign keys that this query uses to identify the relationships…