SQLDMO Help! URGENT!!!!

[AlexCode]

Hi...

 

I'm developing a tool that, using SQLDMO, retrieves the objects from the available SQL Servers.

 

By now, I can retrieve anything but the relationships between tables!!

 

How can I do that?

 

 

Thanks!

 

Alex :p

[HJB417]

relationships might be treated as a rule objects

 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_ob_r_852s.asp

[AlexCode]

Hi... thanks for the reply but...

 

If I connect to the Northwind DB, via SQLDMO, the Rules collection count = 0, but this DB have releationships between tables... :(

[HJB417]

static void OutputDbTableRelationships()
{
SQLServerClass sqlServer = new SQLServerClass();
sqlServer.LoginSecure = true;
sqlServer.Connect("localhost", null, null);
_Database db = sqlServer.Databases.Item("Northwind", null);
foreach(_Table table in db.Tables)
{
	foreach(Key key in table.Keys)
	{
		if(key.Type != SQLDMO_KEY_TYPE.SQLDMOKey_Foreign)
			continue;
		Console.WriteLine("{0}.{1} references {2}.{3}", table.Name, key.KeyColumns.Item(1), key.ReferencedTable, key.ReferencedColumns.Item(1));
	}
}
}

[AlexCode]

Yeah... works!!!

Thanks!

 

Just to add... I had it donne calling a system sp:

 

Dim result As SQLDMO.QueryResults = _

db.ExecuteWithResults("USE " & Me.m_DataBase.Name & " ; EXEC sp_helpconstraint '" & Tables(t).Name & "'")

 

Thanks again.

 

Alex :p