mcs/class/System.Data.Linq/examples/DbLinq.Ora.Example/sql/drop_Northwind_ora.sql

   1 DROP TRIGGER Region_Trigger;\r
   2 DROP TRIGGER Categories_Trigger;\r
   3 DROP TRIGGER Suppliers_Trigger;\r
   4 DROP TRIGGER Products_Trigger;\r
   5 DROP TRIGGER Orders_Trigger;\r
   6 DROP TRIGGER Employees_Trigger;\r
   7 \r
   8 -- Old case insensitive versions... Just in case\r
   9 DROP TABLE OrderDetails;\r
  10 DROP TABLE Orders;\r
  11 DROP TABLE Products;\r
  12 DROP TABLE Customers;\r
  13 DROP TABLE EmployeeTerritories;\r
  14 DROP TABLE Employees;\r
  15 DROP TABLE Suppliers;\r
  16 DROP TABLE Categories;\r
  17 DROP TABLE Territories;\r
  18 DROP TABLE Region;\r
  19 -- New version\r
  20 DROP TABLE "OrderDetails";\r
  21 DROP TABLE "Orders";\r
  22 DROP TABLE "Products";\r
  23 DROP TABLE "Customers";\r
  24 DROP TABLE "EmployeeTerritories";\r
  25 DROP TABLE "Employees";\r
  26 DROP TABLE "Suppliers";\r
  27 DROP TABLE "Categories";\r
  28 DROP TABLE "Territories";\r
  29 DROP TABLE "Region";\r
  30 \r
  31 DROP SEQUENCE Suppliers_seq;\r
  32 DROP SEQUENCE Products_seq;\r
  33 DROP SEQUENCE Orders_seq;\r
  34 DROP SEQUENCE Employees_seq;\r
  35 DROP SEQUENCE Categories_Seq;\r
  36 DROP SEQUENCE Region_seq;\r
  37 DROP SEQUENCE Territories_seq;\r
  38 \r
  39 COMMIT;\r
  40 \r
  41 EXIT\r