DECLARE @tablename varchar(1000)
DECLARE cursor_name CURSOR
FOR select name from sysobjects where name like 'tableName%'
OPEN cursor_name
FETCH NEXT FROM cursor_name
INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
exec ( 'drop table '+@tablename)
FETCH NEXT FROM cursor_name
INTO @tablename
end