Ha.

I missed the DROP TABLE due to the scrolling code window. Otherwise I would have been very confused. But I don't think this distracts from the point the QotD was making.

I had to check whether reorg would re enable the index. And it's only the REBUILD. Which does make sence.

Good question, even with the SELECT and DROP in the wrong order.

Rodders...