title: Teradata: Is it possible to generate an identity column value without creating a record?
body: <p>In Oracle, I used to use sequences to generate value for a table's unique identifier.  In a stored procedure, I'd call sequencename.nextval and assign that value to a variable.  After that, I'd use that variable for the procedure's insert statement and the procedure's out param so I could deliver the newly-generated ID to the .NET client.</p>
  
  <p>I'd like to do the same thing with Teradata, but I am thinking the only way to accomplish this is to create a table that holds a value that is sequentially incremented.  Ideally, however, I'd really like to be able to acquire the value that will be used for an identity column's next value without actually creating a new record in the database.</p>