Thanks you all for the feedback.

I would like to accomplish an automatic way of creating views with the same WHERE condition in more than 90 different tables.

The database stores...

Actually, I need to create 20 views for each database, in the system we have more than 90 databases.

Thus, I was wondering if there is an automated way of creating...