oshkoshbagoshh

Create_Northwind_Database.sql

Aug 2nd, 2021
2,289
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2.  1
  3.  2
  4.  3
  5.  4
  6.  5
  7.  6
  8.  7
  9.  8
  10.  9
  11. 10
  12. 11
  13. 12
  14. 13
  15. 14
  16. 15
  17. 16
  18. 17
  19. 18
  20. 19
  21. 20
  22. 21
  23. 22
  24. 23
  25. 24
  26. 25
  27. 26
  28. 27
  29. 28
  30. 29
  31. 30
  32. 31
  33. 32
  34. 33
  35. 34
  36. 35
  37. CREATE TABLE "Supplier" (
  38. SUPPLIER_ID nvarchar(40)    PRIMARY KEY NOT NULL,
  39. Company_Name nvarchar(40),
  40. Contact_Name nvarchar(40),
  41. Contact_Title nvarchar(40),
  42. City nvarchar(40),
  43. Country nvarchar(40),
  44. Phone nvarchar(40),
  45. Fax nvarchar(40),
  46. Email nvarchar(40)
  47. );
  48.  
  49. CREATE TABLE "Order"(
  50. Order_ID    INTEGER PRIMARY KEY NOT NULL,
  51. Order_Number nvarchar(10),
  52. OrderDate datetime,
  53. Customer_Id INTEGER,
  54. TotalAmount DECIMAL);
  55.  
  56.  
  57. CREATE TABLE "OrderItem"(
  58. Order_ID    INTEGER PRIMARY KEY NOT NULL,
  59. Product_ID  INTEGER
  60. UnitPrice   DECIMAL(12,2),
  61. Quantity    INTEGER);
  62.  
  63.  
  64.  
  65.  
  66. CREATE TABLE "Product"(
  67. Product_Name nvarchar(50) PRIMARY KEY NOT NULL,
  68. Supplier_ID  INTEGER,   /*FOREIGN KEY */
  69. UnitPrice   DECIMAL(12,2),
  70. Package_type    nvarchar(30),
  71. IsDiscontinued bit);
RAW Paste Data