Re: How to Set Up Two One-to-One Tables?

You just need a common primary key:

CREATE TABLE A (x INTEGER NOT NULL PRIMARY KEY, ...)

CREATE TABLE B (x INTEGER NOT NULL PRIMARY KEY REFERENCES A (x), ...)

--

David Portas
SQL Server MVP
--
Received on Thu Aug 11 2005 - 05:15:43 CDT