cursor to drop tables matching a given name in sql server

dopTablesInBulk.sql

select name
  from [tst-IrrigationReporting].sys.tables
 where name like 'YourTableName_2018%'
--   and is_ms_shipped = 0;

DECLARE @cmd varchar(4000)
DECLARE cmds CURSOR FOR
SELECT 'drop table [' + Table_Name + ']'
FROM INFORMATION_SCHEMA.TABLES
WHERE Table_Name LIKE 'YourTableName_2018%'

OPEN cmds
WHILE 1 = 1
BEGIN
    FETCH cmds INTO @cmd
    IF @@fetch_status != 0 BREAK
    EXEC(@cmd)
END
CLOSE cmds;
DEALLOCATE cmds