Alternatively, anyone know of where I can get the EAV model for Erwin?
Sql – find SQL statements to create EAV model?
- Sql – How to list all foreign keys referencing a given table in SQL Server
- Sql-server – the best way to auto-generate INSERT statements for a SQL Server table
- Sql – How to get column names from a table in SQL Server
- Sql – When should I use CROSS APPLY over INNER JOIN
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – Find all tables containing column with specified name – MS SQL Server
- Sql – How to delete using INNER JOIN with SQL Server
Why would anybody want to build an EAV system using a SQL database? It's a square peg in a round hole.
If you are really convinced that EAV is the appropriate solution for your problem domain why not choose a database product which supports it? Cassandra or Voldemort or Dynomite?