• Besides the .* issue which sounds like you plan on fixing. What was also odd was the naming prefix for the views being 'tbl_' for a view. When I see that prefix on a database object I think that it is a table not a view. If you were to prefix a view shouldn't you use 'vw_' or 'v_' or even 'qry_'?

    To follow your intent of a base view you could even prefix 'vw_base_' or something similar.

    If I see [Employee] and [tbl_Employee] in sql or code I would make the assumption that tbl_Employee is actually the table and Employee is a view.

    It would certainly make things less confusing for a DBA or a programmer not familiar with the database. Just another suggestion.

    "There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker