您可以
DROp对所需的表使用动态查询：
DECLARE @ExecSQL AS NVARCHAr (MAX) = '';SELECT @ExecSQL = @ExecSQL + 'DROP TABLE ' + QUOTENAME(S.name) + '.' + QUOTENAME(T.name) + '; ' FROM sys.tables TJOIN sys.schemas S ON S.schema_id = T.schema_idWHERe T.name LIKE '%DynamicSurgery'--PRINT @ExecSQLEXEC (@ExecSQL)
