053. Drop a Table from all Databases – SQL Server Script

--Use sp_MSforeachdb, and execute a command in all databases:

exec sp_MSforeachdb
'use [?]
drop table table_name'