Retrieving the Tables Relationship from SQL Server Database Diagrams

Hi All,

Currently i am defining a simple relationship between
Customers->Orders->Order Details through the Database Diagrams feature in
the SQL 2K. Using the Server Explorer, i can see the Database Diagrams, but
when i try to "drop" the Database Diagrams into the page, it gives the error
message.

I would like to know the procedures to retrieve the database relationships
from Database Diagrams and manipulate them through ADO.NET

I prefer to "convert" already defined relationship using SQL Server Database
Diagrams into XSD file or probably there is another method to "read" those
relationship and manipulate them.

Thank you very much for all your helpI suspect the diagrams are just a view onto the underlying schema. Meaningless without the system tables. Sorry, I know I'd like to use them in that way.|||Hi,

So i need to rebuild the relationships again using XSD because the "Database Diagrams" only related the SQL tables only in SQL Server only ? So there is no workaround for this ?

thanks

hadi|||Having said that you can still get the relationships from ADO, it doesn't need the diagrams to do that. If you're really struggling you could look at ADOX