A view is nothing but a table, for any application that is accessing it. So, the same naming convention defined above for tables, applies to views as well, but not always. A view can be a combination of two tables based on a join condition, thus, effectively representing two entities. In this case, consider combining the names of both the base tables. Most popular example is the ' TitleAuthor ' table from ' Pubs ' database of SQL Server.
Views can summarize data from existing base tables in the form of reports.
Here's the convention that database follows. So, let their name describe the work they do. So, use a verb to describe the work. Similarly, you could name a procedure that inserts a new customer information as ' InsertCustomerInfo '. As explained above in the case of tables, you could use a prefix, to group stored procedures also, depending upon the logical group they belong to.