Microsoft SQL Server forum - Referential Integrity

Author

Referential Integrity

chavasreedhar

2005-12-22, 8:24 pm

Hi

how to set the referential integrity between 2 tables using enterprise
manager (microsoft SQL SERVER).. i tried and the tab doesn't allow me
to choose. pls.help.

thanks
sree

--
chavasreedhar
Message posted via http://www.exforsys.com for all your training needs.

Dan Guzman

2005-12-22, 8:24 pm

Do you have primary keys on your tables? This is a requirement for the
referenced table of the relationship. It is also a Best Practice for all
relational database tables.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"chavasreedhar" <chavasreedhar.20gug3@no-mx.forums.yourdomain.com.au> wrote
in message news:chavasreedhar.20gug3@no-mx.forums.yourdomain.com.au...
>
> Hi
>
> how to set the referential integrity between 2 tables using enterprise
> manager (microsoft SQL SERVER).. i tried and the tab doesn't allow me
> to choose. pls.help.
>
> thanks
> sree
>
>
> --
> chavasreedhar
> Message posted via http://www.exforsys.com for all your training needs.
>

Sponsored Links