Lookup table in Appian Database

Question

Hi, 
 How can we create lookup table in Appian database? 
 
 thanks in advance

Sudha · Accepted Answer

Hi, 
Look up tables are like reference tables.we can create them as like normal tables syntax only.Create table Table name (columns). 
They are used for the purpose of normalization. 
 
CREATE TABLE Types 
(type_id INTEGER, 
 type_name VARCHAR(30)); 
I hope this will help. 
 
Thanks, 
Sudha