r == richard(dot)broersma(at)gmail(dot)com writes:
r> On Thu, Jun 4, 2009 at 1:13 PM, Brandon Metcalf
r> <brandon(at)geronimoalloys(dot)com> wrote:
r> > Is there a way when creating a table to limit it to one row? That is,
r> > without using a stored procedure?
r> Sure just add a check constraint along the lines of:
r> CONSTRAINT Only_one_row
r> CHECK( tableuniqueid = 1 ); --assuming you row has a unique id of 1
Got it. Currently, it doesn't have a column for an ID, but I can add
one if this is the only way.
--
Brandon