How do I safely drop a list of tables, when i have the table names listed in a column?
Something along the lines of the following should work.

CREATE TABLE dbo.TablesToDrop
(
    TableName SYSNAME
);
INSERT INTO dbo.TablesToDrop VALUES ('Table1');
INSERT INTO dbo.TablesToDrop VALUES ('Table2');
INSERT INTO dbo.TablesToDrop VALUES ('Table3');
DECLARE @Cmd NVARCHAR(MAX);
SET @Cmd = '';
SELECT @Cmd = @Cmd + 'DROP TABLE ' + QUOTENAME(t.TableName) + ';'
FROM dbo.TablesToDrop T;
RAISERROR (@cmd, 0, 1) WITH NOWAIT;
--EXEC sp_executesql @Cmd;


Uncomment the last line to actually execute the DROP TABLE statements.