Hi Nirmala, before dropping all the tables, you might need to delete all the relations between them or perhaps you need to delete those tables in a proper order. So you can get the list of the all the tables from the below query.
SELECT sySchema.name, sysTab.name FROM sys.tables AS sysTab INNER JOIN sys.schemas AS sySchema
ON sysTab.[schema_id] = sySchema.[schema_id] WHERE sysTab.name LIKE 'tblEMi%';
So once you are happy with the table names, you can run the below query to provide you the scripts to drop the tables.
DECLARE @sqlQry NVARCHAR(MAX) = '';
SELECT @sqlQry += 'DROP TABLE ' + QUOTENAME(sySchema.name) + '.' + QUOTENAME(sysTab.name) + ';'
FROM sys.tables AS sysTab INNER JOIN sys.schemas AS sySchema ON sysTab.[schema_id] = sySchema.[schema_id]
WHERE sysTab.name LIKE 'tblEMi%';
SELECT @sqlQry;