Subject singleton table with many fields
Author thp_pkmi
Hi all,

I have a table that always contains 1 record and have about 50 fields with various type. It's function is to store system parameters and is accessed very frequent from application and also from database triggers and stored procedures. Is it wise to utilize a singleton table like this, or is it better to implement a table with many records storing parameter name, type, and values ?

Thank you very much.

Regards,
Tjioe