Last Name generator

Last modified: April 3, 2025

The Last Name generator produces realistic and culturally accurate surnames. The generated data can be used in writing, character creation, testing systems requiring name fields, or generating fictitious yet authentic data for simulations and software testing.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
Last Name	Harter, Nicholson, …	character varyingcharactertext	Default

Matching rules

The generator can be assigned to a column that matches any of the following rules:

The column name starts with ‘Last’ or ‘Family’ and ends with ‘Name’, with any or no characters in between, regardless of the table name.
The column name is ‘lname’ or ‘Surname’, regardless of the table name.
The column name starts with ‘Second’ and ends with ‘name’, with any or no characters in between, regardless of the table name.
The column name starts with ‘s’ or ‘e’ as the first character of the column name and ends with ‘name’, regardless of the table name.

Configure additional options

The tool allows you to set additional options:

In the File to load data from box, select … to choose a file to load data from. The default path to the file that stores a list of DE last names is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\LastNames.txt.
Select the Trim left trailing spaces checkbox to remove spaces, tabs, and other non-printing characters on the LEFT of each string.
Select the Trim right trailing spaces checkbox to remove spaces, tabs, and other non-printing characters on the RIGHT of each string (does not remove line breaks).