Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unused Database Table Effects

In our SQL Server Database we have at least 25-35 lookup / empty tables that are never used. Is there any negative effect for keeping them in our database (performance, storage etc)

Basically, would deleteing them have any positive impact on queries etc.

like image 637
mint Avatar asked Mar 12 '26 13:03

mint


2 Answers

Remove them anyway - it's a pain to maintain a database when you have to first figure out what is and isn't being used.

like image 84
HLGEM Avatar answered Mar 14 '26 04:03

HLGEM


No there would be no positive or negative impact to removing or leaving them there, if they are not used. I would remove them.

like image 28
Fosco Avatar answered Mar 14 '26 02:03

Fosco



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!