r == richard.broersma@gmail.com writes:
r> On Thu, Jun 4, 2009 at 1:13 PM, Brandon Metcalf
r> <brandon@geronimoalloys.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