Database Naming Convention Checker
Check table and column names against common database naming conventions with the Database Table Naming Convention Checker.
Database Table Naming Convention Checker
Database Configuration
Choose the SQL dialect.
Table Name
Enter the table name.
Column Names
Enter one column name per line.
What Is a Database Table Naming Convention Checker?
A Database Table Naming Convention Checker validates table and column names against selected database and naming rules. It can help identify reserved words, identifier length issues, leading numbers, and inconsistencies in naming styles.
The tool supports MySQL, PostgreSQL, SQL Server, and SQLite, along with conventions such as snake_case, camelCase, and PascalCase.
How to Use the Database Table Naming Convention Checker
Choose the Database: Select MySQL, PostgreSQL, SQL Server, or SQLite based on your SQL dialect.
Select a Convention: Choose snake_case, plural_snake_case, camelCase, PascalCase, or kebab-case.
Enter the Table Name: Add the database table name you want to validate.
Add Column Names: Enter one column name per line in the Column Names field.
Load an Example: Click Load Example to populate the tool with sample table and column names.
Clear the Input: Use Clear to remove the current table and column names.
Enable Validation Checks: Select the checks you want, including SQL reserved words, identifier length, leading numbers, naming consistency, and naming convention.
Review the Validation: The tool checks the supplied table and column names against the selected database configuration and enabled rules.
Database Naming Example
Input:
Suppose you are using PostgreSQL with the snake_case convention.
Table: customer_orders
Columns: customer_id
order_date
total_amount
shipping_address
An inconsistent version might look like:
Table:
CustomerOrders
Columns:
customerID
order-date
TotalAmount
Validation Options: Enable Check SQL reserved words
Check identifier length
Detect leading numbers
Check naming consistency
Output:
Convention Score: 100%
The checker can help identify naming convention inconsistencies and other potential identifier issues.
Supported Naming Conventions
Snake_case: Uses lowercase words separated by underscores:
Plural_snake_case: Uses plural table names with snake_case formatting:
camelCase: Uses a lowercase first word followed by capitalized words:
PascalCase: Capitalizes each word
Kebab-case: Uses lowercase words separated by hyphens
What Does the Checker Validate?
SQL Reserved Words: Checks whether names conflict with reserved SQL keywords that may require special handling or should generally be avoided.
Identifier Length: Checks whether table or column names exceed the relevant identifier length constraints.
Leading Numbers: Detects names that begin with a number and may therefore create identifier problems depending on the database system.
Naming Consistency: Checks whether table and column names follow a consistent naming style.
Naming Convention: Compares the supplied names against the selected convention, such as snake_case or camelCase.
Frequently Asked Questions
No FAQs available for this tool.