Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Referential IntegrityHi 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.
Post Follow-up to this message
Re: Referential IntegrityDo 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. >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
