indexoff.sql 1.2 KB

123456789101112131415161718192021222324252627282930313233
  1. /*
  2. * The contents of this file are subject to the Interbase Public
  3. * License Version 1.0 (the "License"); you may not use this file
  4. * except in compliance with the License. You may obtain a copy
  5. * of the License at http://www.Inprise.com/IPL.html
  6. *
  7. * Software distributed under the License is distributed on an
  8. * "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express
  9. * or implied. See the License for the specific language governing
  10. * rights and limitations under the License.
  11. *
  12. * The Original Code was created by Inprise Corporation
  13. * and its predecessors. Portions created by Inprise Corporation are
  14. * Copyright (C) Inprise Corporation.
  15. *
  16. * All Rights Reserved.
  17. * Contributor(s): ______________________________________.
  18. */
  19. alter index CUSTNAMEX inactive;
  20. alter index CUSTREGION inactive;
  21. alter index BUDGETX inactive;
  22. alter index NAMEX inactive;
  23. alter index MAXSALX inactive;
  24. alter index MINSALX inactive;
  25. alter index PRODTYPEX inactive;
  26. alter index CHANGEX inactive;
  27. alter index UPDATERX inactive;
  28. alter index NEEDX inactive;
  29. alter index QTYX inactive;
  30. alter index SALESTATX inactive;
  31. ALTER TRIGGER set_emp_no INACTIVE;
  32. ALTER TRIGGER set_cust_no INACTIVE;
  33. ALTER TRIGGER post_new_order INACTIVE;