Actually, sequences appear to be global for most databases. Torque just happens to associate them with a table (where they're most useful). [EMAIL PROTECTED] writes: > dlr 01/06/13 18:32:04 > > Modified: conf/torque/templates/sql/base/sapdb drop.vm > Log: > According to the documentation at > >http://www.sap.com/solutions/technology/sapdb/htmhelp/46/c210705c6611d3a9e500a0c9430730/content.htm, > sequences appear to be per table. > > Revision Changes Path > 1.2 +3 -5 jakarta-turbine/conf/torque/templates/sql/base/sapdb/drop.vm > > Index: drop.vm > =================================================================== > RCS file: /home/cvs/jakarta-turbine/conf/torque/templates/sql/base/sapdb/drop.vm,v > retrieving revision 1.1 > retrieving revision 1.2 > diff -u -r1.1 -r1.2 > --- drop.vm 2001/05/27 02:45:07 1.1 > +++ drop.vm 2001/06/14 01:32:04 1.2 > @@ -1,6 +1,4 @@ > drop table $table.Name cascade constraints; > -#foreach ($col in $table.Columns) > -#if ($col.isAutoIncrement()) > -drop sequence ${table.Name}_SEQ; > -#end > -#end > +#if ($table.IdMethod == "native") > +drop sequence $table.SequenceName; > +#end > \ No newline at end of file > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
