joemoyle wrote: > > Is it possible to add a sequence number to a column when adding a column > to a table in SQL Studio? I seem to be missing something (as usual).
I am not sure to understand you question correctly, but let's try: ALTER TABLE .. ADD .. SERIAL is possible ALTER TABLE .. ADD .. DEFAULT <sequence_name>.NEXTVAL is not possible INSERT T VALUES (.....,<sequence_name>.NEXTVAL, ..) is possible Does this answer your question? Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
