SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t1(i INT);

CREATE TABLE t2(i INT);

CREATE TABLE t3(I INT);

CREATE TABLE tableNotToBeDropped(i INT);
DECLARE @sql NVARCHAR(MAX) = 'DROP TABLE IF EXISTS ' + (SELECT string_agg(QUOTENAME(table_name), ',')
               FROM INFORMATION_SCHEMA.TABLES
               WHERE table_schema = 'dbo' 
               AND TABLE_NAME <> 'tableNotToBeDropped'
               AND TABLE_NAME LIKE 't%');

SELECT @sql;

EXEC sp_executesql @sql;

(No column name)

DROP TABLE IF EXISTS [t1],[t2],[t3]

SELECT *
FROM tableNotToBeDropped;

i

SELECT *
FROM T1;
Msg 208 Level 16 State 1 Line 1
Invalid object name 'T1'.