SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:18 PM
| ||||
| ||||
 Referential Integrity Hi how to set the referential integrity between 2 tables using enterpris manager (microsoft SQL SERVER).. i tried and the tab doesn't allow m to choose. pls.help. thanks sre -- chavasreedha Message posted via http://www.exforsys.com for all your training needs      |
|
02-29-2008, 02:18 PM
| ||||
| ||||
| Re: Referential Integrity 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. > |
 |
« Index on two columns doesn't allow NULL in both - HELP!
|
dynamically trasnpose rows into columns »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:29 AM.
