SQL Generate count(*) for all tables

gen_count_star.sql

select case when ist.ord = 1 then '' else 'union all ' end + 'select ''' + ist.TABLE_SCHEMA + '.' + ist.TABLE_NAME + ''' as table_name, count(*) as cnt from [' + ist.TABLE_SCHEMA + '].[' + ist.TABLE_NAME + ']'
from (
    select *, row_number() over (order by x.table_schema, x.table_name) as ord
      from INFORMATION_SCHEMA.TABLES x
     where x.TABLE_TYPE = 'BASE TABLE'
       and x.TABLE_NAME not like 'MSreplication[_]%'
       and x.TABLE_NAME not like 'MSsaved%'
       and x.TABLE_NAME not like 'MSsubscription[_]%'
       and x.TABLE_NAME not like 'MSsnapshot%'
) ist
order by ist.ord