Foreign Key information
-
How to discover the foreign key information when using the new GetSchema command on the Connection object? I do get FK info, but cannot figure out how the tables and fields in this FK are related. For SQL2005 I get a FK name but not related table and field. Pls help. Or could you give me the SQL query for the problem above?
-
How to discover the foreign key information when using the new GetSchema command on the Connection object? I do get FK info, but cannot figure out how the tables and fields in this FK are related. For SQL2005 I get a FK name but not related table and field. Pls help. Or could you give me the SQL query for the problem above?
Huh?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon