I wanted the remove the table from the sql server database. The table has 500 million records. I don't need the table anymore.

What's the best approach? Can I use drop table command to delete the table permanently? If yes is this the good approach? I want to minimize the transaction log file growth or any other issues while I drop the table. Should I do in off business hours or if the impact is minimal I can it anytime?

SQL server version is both 2017 and 2019. Databases containing those tables have same compatibility and are in full recovery model.


1 Answer 1


DROP TABLE is a minimally logged operation, as already answered here.

So, you can go ahead with the DROP TABLE operation.

  • Thank you for the clarification
    – anu
    Commented Mar 23, 2022 at 21:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.