On 12/28/05 9:53 AM, "Vanja" <milosevski(at)gmail(dot)com> wrote:
> Can someone please tell me how can I add a constraint which will limit
> the number of rows that are allowed to be inserted in a table?
I don't think there is such a constraint (but would love to hear otherwise).
However, you could place a trigger on a table that does a count(*) on the
table (which might be time-consuming on a large table, but....) and then
does whatever you want (ignore the insert, put it in another table, or
delete an old row before inserting the new one). Why do you want to limit
the number of rows?
Sean