declare @s varchar(100) = 'Online_New_PDL_202008';

declare @query nvarchar(max) = N'set quoted_identifier on; with s as
(
 select
  c.name
 from
  ? t cross apply
  (select t.* for xml raw, binary base64, type) a(x) cross apply
  (select quotename(b.n.value(''local-name(.)'', ''sysname'')) from a.x.nodes(''/row/@*[contains(., "@s")]'') b(n)) c(name)
)
select
 ''?'', string_agg(a.name, '', '')
from
 (select distinct s.name from s) a;
';

set @query = replace(@query, '@s', @s);

declare @t table (table_name sysname, columns_list nvarchar(max));

insert into @t
 (table_name, columns_list)
 exec sys.sp_MSforeachtable @query;

select * from @t where columns_list > '';