Normalization and underscore

[Anon]

Hi all!

What are your opinion on underscore in table names? E.g:

shop_product

My friend doesn't want them, I do. He claim that underscores cause problems in Access and VBA. I just think he's a retard using them products...

But, are there any concerns in using underscores in table namen?

Thanx.

Cheers,

Anders

[Anon]

There are definatly no problems with underscores, but their use can range widely.

I have a few tables that use underscores in their -regular- column names. I regret doing it this way now. Fortunatly I have a lot of tables that don't use them in regular column names.

Here are reasons they should be used:

I use ref{parenttable} for ALL my foreign keys so they are easily distinguished and I use no 's in regular columns. All my primary keys are tablename_key.

I use _'s appended to sequences, views, indexes, and any other non-table entities in my database too such as someview_view or sequencename_seq or myindex_idx

I, of course, think my way is best 🙂

[Anon]

To more specificly answer your question, I don't use in tables becaue I never know where the would occour....was that table dbuser_names or db_user_names? In this case I would use dbusernames as the table, but my rule from the previous post about _view, etc. still holds.