Constraint UNIQUE (SQL)

UNIQUE: used for secondary / alternate keys

DNAME CHAR(9) UNIQUE;