I have an SQL database with over 100 tables.

I have a list of the table names.

I do NOT want to make 100+ remote views to open those files or click on the 100 tables for design view.

How can I go down the list of tables and get the number or records in each table?