Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. CONSTRAINT FK_A_B FOREIGN KEY(A_Key)
  2. REFERENCES B(B_Key),
  3.  
  4. CONSTRAINT FK_B_A FOREIGN KEY(B_Key)
  5. REFERENCES B(A_Key),
  6.  
  7. CREATE TABLE [Person](
  8.  
  9. [PersonID] [int] PRIMARY KEY NOT NULL,
  10. [FirstName] varchar(20) NOT NULL,
  11. [MiddleName] varchar (20) NULL,
  12. [LastName] varchar(20) NOT NULL,
  13.  
  14. )
  15.  
  16. CREATE TABLE [PersonInfo](
  17.  
  18. [PersonID] [int] FOREIGN KEY REFERENCES [dbo].[Person] (PersonID) NOT NULL,
  19. [Phone] varchar(20) NOT NULL,
  20. [Email] varchar (20) NULL,
  21. [Address] varchar(20) NOT NULL,
  22. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement