SAP DB is now SAP MaxDB! For more information, visit the SAP MaxDB pages in the SAP Developer Network.

How to Produce Number Generators

Catchwords: SEQUENCE, SERIAL, auto_increment, IDENTITY, NEXTVAL, CURRVAL

Use

• CREATE SEQUENCE statement

  Generation of numbers for cross-table use

  See also:
  Reference Manual: SAP DB 7.2 and 7.3 ® Data Definition ® CREATE SEQUENCE Statement.
  
  
  
  
• SERIAL data type

  Generation of numbers for a single column of a table

  See also:
  Reference Manual: SAP DB 7.2 and 7.3 ® Data Definition ® CREATE TABLE Statement® Column Definition ® Data Type

This site is sponsored by SAP AG.