With SQL Server database, I would like to create an Entity Relationship diagram with table, index, key, store procedures, and views.
1. If dealing with new model - create procedures via Text objects.
2. If dealing with Reverse Engineering:
For SQL Server 2000 has following options:
*load filegroup for tables, indexes and constraints
*load referential integrity
*load check constraints
*load unique constraints
*load indexes
*load fill factor
*load collations for columns
*load description for tables and columns
*load triggers
*load procedures
*load functions
*load views
*load users and groups
*load permissions
For SQL Server 2005 has the following options:
*load dataspace for tables, indexes and constraints
*load referential integrity
*load check constraints
*load unique constraints
*Don't load system generated names of check and default constraints
*load indexes
*load fill factor and IGNORE_DUP_KEY option
*load collations for columns
*load description for tables and columns
*load triggers
*load DDL triggers (to BeforeScript)
*load procedures
*load functions
*load aggregate functions
*load views
*load synonyms
*load XML schema collections
*load partition functions
*load partition schemes
*load assemblies
*load fulltext catalogs and fulltext indexes
*load users and groups
*load permissions
