Re: Question on creation of a table

From: Michael Bierenfeld <michael.bierenfeld_at_ibsgmbh.de>
Date: Wed, 20 Jan 1999 13:07:26 +0000
Message-ID: <36A5D50E.F7B76FF@ibsgmbh.de>

arunal_at_hotmail.com wrote:

> Hi all, I want to create a table with only one record. While creating the
> table using create table command itself i want to include some
> condition/constraint which restricts the table to contain only one row. Has
> anyone come across such a situation. If so please let me know. Any help in
> this regard is greately appreciated. thanx in advance regards aruna
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

One possible solution would be to create a BEFORE INSERT Trigger on this table.

The trigger count(*)`s the number of rows in this table If the number is >= 1 it raises an error.
The applications has to react on this.

Regards

Michael Received on Wed Jan 20 1999 - 07:07:26 CST