Mods move this if you thing it belongs somewhere else.

I'm working on an application that connects to a SQL Server database (2005 and up only) that will allow a user to see all the information on a table.

i.e. Tab 1 is field information - name datatype, size, defaults, is Identity and Nullable ....
Tab 2 is Referencing tables - Who are my parents - Parent table name, FK name, Key fields in the table and Referencing fields in parent table. Also tables that this on is a Parent of - Child table name, FK name on the child table, and field info again.
Tab 3 is Indexes on the table- Index name, Clustered or Non Clustered, File group the index is on, Is Primary Key, Index Columns and Is Unique
Tab 4 Check constraints - Constraint name and constraint values
Tab 5 Programability - Functions and Stored Procedures that reference the table. Procedure / Function Name, Type ( Function or SP), Date Created, Last Modified Date and SP or Function Text displayed if requested.
Tab 6 Triggers on the table - Trigger name IsUpdate, IsDelete, IsInsert, IsInsteadOf and Status (Enabled or Disabled)
Tab 7 Views that reference the table - View Name, Check Option, Is Updateable, Created date and View code if requested.


I was looking to see if any one would be willing to try the app and let me know of issues improvements.

Thanks

Gary