|
Posted by Dan Guzman on 12/23/05 04:17
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.
>
Navigation:
[Reply to this message]
|