Congrats on using naming conventions! In my view tbl is a sufficient prefix
for a table name. I don't think it's necessary to have table types in the
prefix. Tables only have one function, to hold data, so all tables are
essentially equal. If you do decidd to use special naming conventions for
lookup tables, etc., as long as you're consistent it doesn't matter which one
you pick.


"dee" wrote:

I am creating a database and trying to stick to standard naming conventions,
using prefixes such as tbl frm, etc.

I have come across two definitions of lookup tables - tlkp and tlu - and am
not sure which to use.

I also see tjx for join table and ttbl for title table, but am unclear as to
what these do, especially the title table.

Any guidance would be appreciated!
--
Thanks!

Dee