Hello Arnaud, looking at the CREATE TABLE statement the documentation leads to the definition of the a column, and here, to the DEFAULT specification at: http://www.sapdb.org/7.4/htmhelp/d0/7638a1d21c11d2a97400a0c9449261/content.htm
and here, the last entry in the table, DEFAULT SERIAL, is very probably what you are looking for. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: arnaud barbe [mailto:[EMAIL PROTECTED] > Sent: Friday, November 07, 2003 5:20 PM > To: [EMAIL PROTECTED] > Subject: increment > > > hi > > CREATE TABLE reservation (rno FIXED(4) PRIMARY KEY, cno FIXED(4), hno > FIXED(4)) > > is it possible to define a key increment (rno) in create > table statement > (like auto_increment in mysql) ? > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
