MS Access DDL Example:

CREATE TABLE PMP_codes_table ( code_type TEXT(8),  code TEXT(10),  decode TEXT(50),  
update_date DATETIME,  update_time DATETIME, CONSTRAINT myKeyFields 
Primary Key (code_type, code)); 

---