Database Naming Conventions – Case for Tables and Columns
Published 2026-02-23 · convertcase.in
Consistent naming conventions in databases improve readability, maintainability, and cross-platform compatibility. Here's the definitive guide.
Try it now — free instant conversion
No signup · No limits · Works on all devices
1Table Names
Convention: snake_case, plural. Examples: users, user_profiles, order_items.
2Column Names
Convention: snake_case. Examples: first_name, created_at, is_active.
3PostgreSQL vs MySQL
PostgreSQL: lowercases unquoted identifiers — always use lowercase or quote identifiers. MySQL: case sensitivity depends on OS file system.
4Stored Procedures
snake_case for procedures: get_user_by_id, create_order_item.
Frequently Asked Questions
Should database column names use camelCase or snake_case?
snake_case is the dominant convention for SQL databases. camelCase is used in NoSQL (MongoDB) when the API is JavaScript-based.