Extract relationship from sql server...

[Samuel]

Hi,
I have a problem....
I am connect with adodb with sql server.
In this data base i have many tables, and all tables
have a Primary Key, a Foreign Key and they are relationship.
How I do for extract the relationship between tables and their Key (if they are primary or foreign key)?
I know that there is a command (or property) in Visual Basic6 that say me this things... but I don't know wich is the command!
thanks and sorry for my english

[JHausmann]

You could execute the stored procedure "sp_help", passing the table name as a parameter (ie; sp_help tablename).