I'm hoping someone has a trick to do this. I have a lot of lists that were saved from extractions that I was working on for mailing/telefunding campaigns, that I have since then decided not to use, but I am unable to delete them.
I get the error message that this list is in use and cannot be deleted but I have gone through so many of my lists and extractions and do not see any of these lists in use (nor should any of my collegues be using them.)
How can I delete???? I know I could just inactivate them, which I have. But they still show up in list manager and I would like to get rid of them all together because their presence is more confusing than anything else.
Suggestions???
I use the following to delete lists, it clears them from t_list_contents and then allows you to delete the list.
DELETE FROM T_LIST_CONTENTS WHERE LIST_NO in (
select list_no from t_list where list_no = xxxx)
Then this:
delete t_list
where list_no = xxxx