Database table naming conventions

Specifically, I'll describe naming conventions for database objects, why they are so important, and what you should and shouldn't be doing.

• Warning! ...
• Avoid quotes. ...
• Lowercase. ...
• Data types are not names. ...
• Underscores separate words. ...
• Full words, not abbreviations. ...
• Use common abbreviations. ...
• Avoid reserved words.

1. What are naming conventions in a database?
2. What is the right naming convention for table?
3. What is the naming conventions of a database in SQL?
4. How do you name a database name?

What are naming conventions in a database?

I've already stated it in the intro, but more generally, a naming convention is a set of rules you decide to go with before you start modeling your database. You'll apply these rules while naming anything inside the database – tables, columns, primary and foreign keys, stored procedures, functions, views, etc.

What is the right naming convention for table?

Table prefix and suffix must be compatible with the table type. Table names must have only A to Z, 0 to 9, and underscore (_) characters. Table names can have multiple underscores. For more information, see the Table Naming Conventions section.

What is the naming conventions of a database in SQL?

Each table name should have a “tbl” prefix. The next word after the “tbl” prefix should be the table name. The first letter of the table name should be capitalized. The last word of the table name should be end with the character "s" (or "es") to indicate plural.

How do you name a database name?

Database Names

1. Database names must only consist of the letters a to z (both lower and upper case allowed), the numbers 0 to 9, and the underscore (_) or dash (-) symbols This also means that any non-ASCII database names are not allowed.
2. Database names must always start with a letter.