Это моя первая программа на C#, не судите строго.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
static void Main(string[] args)
{
SqlConnection myConnection;
myConnection = new SqlConnection( "integrated security=SSPI;data source=\" .\ ";initial Catalog=pubs" );
myConnection.Open();
SqlCommand myCommand = new SqlCommand(
"SELECT col1.name AS fcolumn, so1.name AS ftable, "
+ "col2.name AS rcolumn, so2.name AS rtable, fk.keyno "
+ "FROM sysforeignkeys fk "
+ "INNER JOIN syscolumns col1 ON fk.fkey = col1.colid AND fk.fkeyid = col1.id "
+ "INNER JOIN sysobjects so1 ON fk.fkeyid = so1.id "
+ "INNER JOIN syscolumns col2 ON fk.rkey = col2.colid AND fk.rkeyid = col2.id "
+ "INNER JOIN sysobjects so2 ON fk.rkeyid = so2.id"
,myConnection
);
SqlDataReader myDR = myCommand.ExecuteReader();
while (myDR.Read())
{
Console.WriteLine( "FOREIGN KEY " + myDR[ "ftable" ] + "(" +
myDR[ "fcolumn" ].ToString() + ") REFERENCES " +
myDR[ "rtable" ] + "(" +
myDR[ "rcolumn" ].ToString() + ")"
);
}
myDR.Close();
myConnection.Close();
}
На самом деле картинка которую она показывает не совсем точная (составные ключи разбиты по отдельным колонкам).
Результат работы:
FOREIGN KEY titles(pub_id) REFERENCES publishers(pub_id)
FOREIGN KEY titleauthor(au_id) REFERENCES authors(au_id)
FOREIGN KEY titleauthor(title_id) REFERENCES titles(title_id)
FOREIGN KEY sales(stor_id) REFERENCES stores(stor_id)
FOREIGN KEY sales(title_id) REFERENCES titles(title_id)
FOREIGN KEY roysched(title_id) REFERENCES titles(title_id)
FOREIGN KEY discounts(stor_id) REFERENCES stores(stor_id)
FOREIGN KEY pub_info(pub_id) REFERENCES publishers(pub_id)
FOREIGN KEY employee(job_id) REFERENCES jobs(job_id)
FOREIGN KEY employee(pub_id) REFERENCES publishers(pub_id)
