sql server 2005批量删除表

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