Question about a default table or method
Vincent Johns wrote:
"miscellaneous" Table has worked well for me, too.
A single row table of constants is a standard SQL trick which works
well. Of course you have to ensure it never contains more than one row
e.g.
CREATE TABLE Constants (
lock CHAR(1) DEFAULT 'x' NOT NULL PRIMARY KEY,
CHECK (lock = 'x'),
other columns...
);
|