Retrieving Table Relationships or Joins

You may be able to obtain that information using SQLDMO or ADOX. The relationship is called a "foreign key constraint."

Yes, you may use ADOX or SQLDMO with .NET. I do not know of any way to obtain this information via ADO.NET, but you might try searching the Web.

It appears to me that you're looking for a "reverse engineering" tool that can generate an entity-relationship diagram for your database. There are several products on the market that can attempt to do this; ERwin by Computer Associates comes to mind. Be aware that this kind of reverse-engineering becomes quite difficult if the corresponding foreign key and primary key field names don't match. This happens even on commercial-grade systems. Good luck.

Hello guys,
I found some code that solved my problem so I thought this can be useful.

This is the code:

DataTable schemaTable;

//This code retrieves the foreign keys of all the tables in a Schema
schemaTable = cnn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys, new Object[] {null, theSchema, null});

foreach(DataRow myRow in schemaTable.Rows)
{
String PK_TABLE_NAME = myRow ["PK_TABLE_NAME"] as String;
String PK_COLUMN_NAME = myRow ["PK_COLUMN_NAME"] as String;
String FK_TABLE_NAME = myRow ["FK_TABLE_NAME"] as String;
String FK_COLUMN_NAME = myRow ["FK_COLUMN_NAME"] as String;
}

Where:

PK_TABLE_NAME = The table that contains a Primary Key
PK_COLUMN_NAME = The Field used as Primary Key
FK_TABLE_NAME = The table that has a relation with the table that contains the Primary key (PK_TABLE_NAME)
FK_COLUMN_NAME = The field name that is used as a foreign key and is contained in the related table (FK_TABLE_NAME)

Hope this could help others.
:WAVE: