To delete records of a separate search space for a category do the following:
- Open a command window, which corresponds to the database that you are using.
- Run the following SQL statements:
Refer to the WebSphere Commerce Installation Guide for information on how to run the SQL statements against the WebSphere Commerce database.
- delete from ICEXPLFEAT where CATGROUP_ID=xxxx
- 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))
- delete from ICROOTCAT where CATGROUP_ID=xxxx
- drop table ICTxxxx
- drop table ICTDESCxxxx
- drop view ICVxxxx_NULL
where, xxxx is the category reference number and storeId is the store reference number associated with the category.