by Stev » Thu, 11 Dec 2003 18:23:27
by Jacco Schalkwij » Thu, 11 Dec 2003 18:45:05
--
Jacco Schalkwijk
SQL Server MVP
Quote:> How can we create a table with one FOREIGN KEY column that refrences a
table
> with two or more PRIMARY KEYS? (I need just one of the primary keys for
> referencing)
by Vishal Parka » Thu, 11 Dec 2003 18:41:10
I guess you mean to say a primary key with more than one column that isQuote:> with two or more PRIMARY KEYS? (I need just one of the primary keys for
--
- Vishal
1. foreign key w/o foreign/primary key
Does anyone have an opinion on the most efficient way to check
referential integrity on a table where the would-be foreign key is
neither unique or primary? Would I use a check constraint? If so, how
without a subquery?
Thanks in advance,
Sent via Deja.com
http://www.deja.com/
2. Number of processes per connection
3. BCP INTO A TABLE THAT CONTAINS PRIMARY KEY AND FOREIGN KEY CONSTRAINTS
4. Announce: Fast ODBC Drivers On WEB
5. DMO and Tables +Primary Key - Foreign Key
7. display primary keys, foreign keys of a table.
9. Table Design Question: Foreign keys when child has one of two parents
10. Two Tables, One Primary Key
11. Primary Key / Working Code to get primary key of a table using ADO and schemas
12. Foreign Key as subset of Primary Key
13. Identification of a primary key/foreign key