Skip to main content

Is there a way to remove tables from ODX storage that have been deleted in the desktop, similar to the SQL Database cleanup tool available in the DW? My use case is when SQL Storage is used for the ODX.

The “Remove unused object” option does not drop tables it seems. The Storage Management Task is good of course, but we can’t use it for deleted data sources.

Let’s say I have transferred a large table hundreds of times into my ODX and then deleted the data source. Can I remove them without having to drop the tables manually in SSMS?

Best,

Pontus 

Hi @pontus.berglund 

No it can’t clean it from within the program, you will have to do it from another program.

I see if more as a new feature. Are you able to change the original wording to be more like that?

Then I can change it to a suggestion instead of a question.


Hi @Thomas Lind,

Ok thanks for letting me know. Yes that would be a new feature then. I can rewrite the post and post it in the ideas section.


I have posted it as an idea: 

 


Reply