Search code examples
databasenumbersnamingconvention

Numbers on table name

Is it okay that I use numbers for table names in my database

For example

 create table `tbl_love143`;

Is it a good naming convention?

Solution

  • If your database engine permits numbers, I see no reason not to use them. However, given your example of tbl_love143, does this mean you have 142 other 'love' tables? if so, there is something seriously wrong with your database design!

    In summary, numbers are fine, but having multiple tables that store the same 'type' of information is not.