"Mark" <mchung_pc@hotmail.com> wrote in message
news:1117734724.479577.321970@o13g2000cwo.googlegr oups.com...
> Hi,
>
> How to add a foreign key constraint using the SQL server 2000
> enterprise manager?
> Not by SQL.
>
> thanks
>

I think you have to create a database diagram, then manage relationships in
that somehow, but I don't really know - EM is not a very good tool for
database design or programming. I would do it in Query Analyzer, because
then you have complete control over what you're doing and you also have a
script you can save, put under version control, run against multiple
databases etc.

Simon