View Single Post
  #24  
Old November 14th, 2005, 12:46 PM
external usenet poster
 
Posts: n/a
Default 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...
);