1 Jul
2010
1 Jul
'10
2:27 p.m.
On 01-07-2010 08:08:14 -0400, Mark Bucciarelli wrote:
Hi,
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?
Yes, it's stored in the sequence table iirc. JDBC and msqldump have queries to retrieve them (to reconstruct a create sequence statement).
Alternatively, is there a way to specify the sequence name when creating the table?
how about: create sequence "bla" ... create table "foo" (id sequence "bla"); (plus/minus obvious mistakes in SQL)