How do I safely drop a list of tables, when i have the table names listed in a column? Assuming I have a database column containing table names, how do I safely delete all of the tables it lists?

The tables themselves are fairly simple - they may have indeces, but definitely don't contain other complex items (and don't have dependencies on other tables - ie, foreign keys into/out of them, etc...)
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.