Thank you again. As I search the documentation and archives I'm stuck at points not knowing what to call something in MaxDB. I was looking for the MaxDB equivalent of MS SQL identity. I believe that SERIAL is what I was looking for. I have figured out how to use it in the GUI and my load scripts.
-----Original Message----- >From: Zabach, Elke<[EMAIL PROTECTED]> >To: joemoyle<[EMAIL PROTECTED]>; MaxDB Lists<[EMAIL PROTECTED]> >CC: >Sent: Thursday, July 01, 2004 2:13:00 AM >Subject: AW: SEQNO in SQL Studio 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]
