Bulk alter SQL column data value in MS-SQL2019 in a Trans-Sql

1

Hi,

A newbie here, how to bulk update data in SQL column? For example my database name is "abcDB"

I have multiple tables in "abcDb" that start with .dbo.sun_001 to .dbo.sun_020.

In every .dbo.sun_001 to dbo.sun.020 tables there is one column name "server" that I would like to change the value from Dns02 -> Dns04 for all the row.

Any advise on a single to two command to do it in the most simplest way? Appreciate very much