We have worked with many different databases over the years, and we have seen many different naming conventions for tables and columns. Some of the naming conventions we have encountered are great, and others are simply awful.
If you are curious to know what conventions are followed by the database development team at InSite, one of our developers has posted a great article on the topic.
SQL Server Table and Column Naming Conventions
The article describes standard naming conventions for tables and
columns, and it provides code that leverages the conventions to do some
useful things like dependency visualization and foreign key constraint