Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. CREATE TABLE dbo.Invoices
  2. (
  3. InvoiceID int PRIMARY KEY,
  4. CustomerID int, -- FOREIGN KEY REFERENCES dbo.Customers...
  5. InvoiceDate date,
  6. ...
  7. );
  8.  
  9. CREATE TABLE dbo.InvoiceDetails
  10. (
  11. InvoiceDetailID int PRIMARY KEY,
  12. InvoiceID int NOT NULL FOREIGN KEY REFERENCES dbo.Invoices(InvoiceID),
  13. ProductID int, -- FOREIGN KEY REFERENCES dbo.Products...
  14. Quantity int,
  15. ...
  16. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement