US National Drug Code (FDA NDC) generator
Last modified: April 3, 2025
The US National Drug Code (FDA NDC) generator creates valid and structured National Drug Codes (NDCs) to identify pharmaceutical products within the United States. The NDC is a unique, universal identifier maintained by the U.S. Food and Drug Administration (FDA) for drugs approved for human use.
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 |
---|---|---|---|
FDA NDC | 33012-871-53, 5419-0900-12, …3301287153, 5419090012, … | character varyingcharactertextdecimalbigint | Default |
Matching rules
The generator can be assigned to a column that matches any of the following rules:
- The column name starts with ‘National’, then goes ‘Drug’, preceded or followed by any or no characters, and ends with ‘Code’, regardless of the table name.
- The column name starts with ‘FDA’, then goes ‘NDC’, preceded or followed by any or no characters, and ends with ‘Code’, regardless of the table name.
- The column name starts with ‘FDA’ and ends with ‘NDC’, with any or no characters in between, regardless of the table name.
Configure additional options
The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.
Preview of the column data generated by the US National Drug Code (FDA NDC) generator
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for PostgreSQL.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.