• Just to reinforce what Jeff has said. I have also found views with a prefix of "tbl", I think for the same reasons - something started off as a table and the structure evolved over the years until it was changed to a view - so it may sound daft but it does happen.

    So to me I would absolutely avoid:

    tables with the prefix tbl

    stored procs prefixed usp_ - it is just pointless letters

    data types included in column names

    Mike John