Deprecated featureDeprecated feature

Deleting separate search space for a category

This steps in this section explain how to delete separate search space for a category.

Procedure

  1. Open a command window, which corresponds to the database that you are using.
  2. Run the following SQL statements:
    1. delete from ICEXPLFEAT where CATGROUP_ID=xxxx
    2. delete from ICTPRICES where STOREID= storeId AND (CATENTRY_ID in (select CATENTRY_ID from CATGPENREL where CATGROUP_ID=xxxx) or CATENTRY_ID in (select CATENTRY_ID_CHILD from CATENTREL , CATGPENREL where CATENTRY_ID_PARENT=CATENTRY_ID and CATGROUP_ID=xxxx))
    3. delete from ICROOTCAT where CATGROUP_ID=xxxx
    4. drop table ICTxxxx
    5. drop table ICTDESCxxxx
    6. drop view ICVxxxx_NULL where, xxxx is the category reference number and storeId is the store reference number associated with the category.