limit TABLE to only one record

From: Brian Tkatch <N/A>
Date: Wed, 14 Nov 2007 13:55:54 -0500
Message-ID: <gvdmj3d5svp608hfabq596n8bn2bo1pons@4ax.com>

I am looking to store an easily modifiable value that a VIEW can use, without issuing any DDL statements. I'm guessing that a TABLE with one record would be a good way. The question then is how to limit a TABLE to only one record:

CREATE TABLE One_Record_Only
(

 Id			INT	DEFAULT 1,
 Data			INT,
 CONSTRAINT ORO1_Id_NN	CHECK(Id IS NOT NULL),
 CONSTRAINT ORO1_Id_CK	CHECK(Id = 1),
 CONSTRAINT ORO1_Id_PK	PRIMARY KEY(Id)

  USING INDEX (CREATE UNIQUE INDEX ORO1_Id_PK ON One_Record_Only(Id)) );

 Is there a more straightforward emthod to limit a TABLE to only one record?

 Is there another way to accomplish the same goal?

B. Received on Wed Nov 14 2007 - 12:55:54 CST