Creating and Managing Lookup Table

The method of creating the reference table is as follows.

Creating Lookup Table

CREATE LOOKUP TABLE lktable (id INTEGER PRIMARY KEY, name VARCHAR(20));

Lookup Table must specify Primary key.

Deleting Lookup Table

DROP TABLE lktable;