Originally Posted by felgall
A one column table would need to have its column as part of the key in the other tables that refer to it. Its purpose would be to limit the values that can be contained in that column in the other table(s) to the values in the one column table.
An reasonable is a simple lookup table. Say something like
CREATE TABLE AvailableColors(
color VARCHAR(20) PRIMARY KEY
INSERT INTO AvailableColors
VALUES('Red'),('Blue'),('Black'),('White'),('Pink polka dots');