Chris Hammond · Chris Hammond
Last Updated
DotNetNuke Daily Tip #3 6/26/06
Learn how to clear search tables in DotNetNuke with this helpful tip from Chris Hammond on 6/26/2006. SQL commands included. Contact for more Daily Tips!
DotNetNuke Daily Tip for 6/26/2006
During your development you may run across a time when you need to clear out the search tables for DotNetNuke’s searching engine. Here’s the SQL to do so.
delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem
Thanks to Mark Gorla from Engage Software for providing this tip.
Do you have a question about DotNetNuke? Perhaps I can answer it here as a Daily DotNetNuke Tip! Email chris.hammond at dotnetnuke.com with your question! Be sure to put Daily Tips in the subject line.
