All tools
Naming
Abbreviation & Naming
Turn business terms into standard abbreviated names for database columns and code, with your team's dictionary.
Business terms
7 names · one per line · camelCase and snake_case input both work
Results
cust_acct_no12customer → custaccount → acctnumber → notxn_amt7transaction → txnamount → amtdt_birth8date → dtofbirthord_itm_qty11order → orditem → itmquantity → qtycrt_ts6created → crttimestamp → tsemp_dept_cd11employee → empdepartment → deptcode → cdcust_pri_residential_mailing_addr_verification_sts50customer → custprimary → priresidentialmailingaddress → addrverificationstatus → sts
Your dictionaryStandard dictionaryAuto-shortenedNot in dictionaryFiller word dropped
Look up an abbreviation
280 standard abbreviations. Start typing to search.
Your team dictionary (0)
- Add your organisation's own standards here. They override the built-in dictionary.
Saved in this browser. Export to share with your team.
Making naming a team standard
- Add your organisation's preferred abbreviations in Your team dictionary — they override the built-in ones. Click Export and commit
abbreviations.jsonto your repo so everyone can Import the same standard. - Pick the max length of your database to keep identifiers valid: Oracle ≤ 12.1 allows 30 characters, PostgreSQL 63, MySQL 64, SQL Server 128.
- Avoid SQL reserved words such as
order,userordateas column names — the tool flags them. - Use Expand to decode existing column names (e.g.
cust_acct_no) into readable labels for reports and documentation.