Re: [MonetDB-users] sql: getting (or specifying) sequence name

1 Jul 2010


      On Thu, Jul 1, 2010 at 8:08 AM, Mark Bucciarelli  wrote:
...
Given a table with a sequence that controls
the primary id, is there a SQL command I
can run to get the name of that sequence?
Never mind, sqlmanual.pdf to the rescue.

SELECT
   default
FROM
   columns
WHERE
   table_id = %d AND
   name = 'id'
;

Thanks,

m