Hi experts,

which approaches would you suggest for:

 - Reading a database schema (tables, fields, relationships) from SQL
Server 2005?
 - Visualizing the DB schema?

For developing a DB tool the schema should be read from the server and
then be visualized, e.g. like the SQL Server BI Development Studio
does when importing the whole schema to a data source view.

Any ideas and hints on how to start approaching this (either reading
schema and/or visualizing it) using .NET (preferably C#) are welcome!


Regards,
Max

Max,

http://support.microsoft.com/kb/309488

I usually display the schema table info in a grid by binding the returned 
table to a control like a datagridview.

Kerry Moorman


"send.me.all.email@googlemail.com" wrote:


> Hi experts,
> 
> which approaches would you suggest for:
> 
>  - Reading a database schema (tables, fields, relationships) from SQL
> Server 2005?
>  - Visualizing the DB schema?
> 
> For developing a DB tool the schema should be read from the server and
> then be visualized, e.g. like the SQL Server BI Development Studio
> does when importing the whole schema to a data source view.
> 
> Any ideas and hints on how to start approaching this (either reading
> schema and/or visualizing it) using .NET (preferably C#) are welcome!
> 
> 
> Regards,
> Max
> 
>