Programming & Development / April 11, 2025

How to Represent Denmark’s Regions in Java and SQL Using ISO 3166-2 Codes

Denmark regions Java enum Denmark ISO 3166-2 DK SQL Denmark regions DK region codes Denmark administrative divisions Spring Boot enum Denmark region list backend region enum

🇩🇰 Java Enum: Denmark’s Regions

Denmark is divided into 5 administrative regions. Here's the Java enum with their ISO codes:

java

public enum DenmarkRegion {
    CAPITAL_REGION("DK-84"),
    CENTRAL_DENMARK_REGION("DK-82"),
    NORTH_DENMARK_REGION("DK-81"),
    REGION_OF_SOUTHERN_DENMARK("DK-83"),
    REGION_ZEALAND("DK-85");

    private final String code;

    DenmarkRegion(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE denmark_regions (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO denmark_regions (name, code) VALUES
('Capital Region of Denmark', 'DK-84'),
('Central Denmark Region', 'DK-82'),
('North Denmark Region', 'DK-81'),
('Region of Southern Denmark', 'DK-83'),
('Region Zealand', 'DK-85');

✅ Summary

This setup allows you to work efficiently with Denmark’s 5 administrative regions in both Java and SQL using official ISO 3166-2:DK codes.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex