Koen Verbeeck (10/20/2013) kevaburg (10/19/2013)
Richard Warr (10/18/2013)
Alternatively, petition for the UNDROP TABLE command to be introduced in SQL Server 2016.
Hope you found a way to get the table recreated from somewhere.
Personally I would like to see a $RECYCLEBIN object for SQL Server such as Oracle has. This would be extremely good in such a situation......
It would be a great addition in a development/testing environment, however possibly a waste of resources in a tightly managed production environment.
You might have a point but only a small one I think.
The recyclebin only contains the text statement so its size remains compatively small. In contrast to SQL Server, the restoration of a table can be done online meaning no downtime.
Alternatively, a technology such as FLASHBACK TABLE TO BEFORE DROP could also be a life/job/money saver.
There a lot of lessons Microsoft could learn from Oracle in this area and I ask myself alot why it hasn't been more seriously addressed.