DB Schema

[jkhome]

For a new application i would like to retrieve all database information
ie tables,fields, if they are a foreign key etc

A couple of ways i have looked into doing this is GetSchema and using
INFORMATION_SCHEMA in a select statemen. I have took at many examples
but nothing seems to explain them in enough depth. Could someone
explain them to me and which one is better to use. If anyone could give
me some examples of how to use them that would be great.

 

[Frans Bouma [C# MVP]]

For a new application i would like to retrieve all database
information ie tables,fields, if they are a foreign key etc

A couple of ways i have looked into doing this is GetSchema and using
INFORMATION_SCHEMA in a select statemen. I have took at many examples
but nothing seems to explain them in enough depth. Could someone
explain them to me and which one is better to use. If anyone could
give me some examples of how to use them that would be great.

INFORMATION_SCHEMA suggests you're using SqlServer (as that database
is the only one implementing some of these ansi views). ?

You can get very far with INFORMATION_SCHEMA views, sometimes you have
to perform some joins with other INFORMATION_SCHEMA views to get the
real info you want. Which info wasn't retrievable for you?

FB

--