Further, indexes can be of two types, clustered and nonclustered. These two types of indexes could be either unique or non-unique. So, the naming convention should take care of the index types too. In this case, just concatenate the column names together, just the way we did with junction tables and views above. So, it's not a pain, but it's a very useful naming convention.
Columns are attributes of an entity, that is, columns describe the properties of an entity.
So, let the column names be meaningful and natural. As shown above, it'll be a good idea to prefix the column names with the entity that they are representing. Here's another idea. Decide on a standard two to four character code for each table in your database and make sure it's unique in the database. For example 'Cust' for Customers table, 'Ord' for Orders tables, 'OrdD' for OrderDetails table, 'Adt' for Audit tables etc.