Get Relations betwwen the tables?

[Mohammad Al Hus]

i want to write program that will return
the relations between the tables and its type (one to many,.....etc)
any help
Thanks in advance

[skhanal]

You can query the system catalog get that information. In SQL Server it will be in syscontraints and sysobjects.

[MAK]

look at the logic behind sp_helpconstraint.

use master
go
sp_helptext sp_helpconstraint
go






example:


create table mytable (id int identity(1,1) constraint mytable_pk primary key,
name char(100) constraint mytable_def default ('NoName'))
go
sp_helpconstraint mytable
go

[Mohammad Al Hus]

Thanks For All
I will try This Solutions
Thanks again