Browse-mode restrictions  Timestamping an existing table

Chapter 18: Cursors: Accessing Data

Timestamping a new table for browsing

When creating a new table for browsing, include a column named timestamp in the table definition. This column is automatically assigned the timestamp datatype; you do not have to specify its datatype. For example:

create table newtable(col1 int, timestamp,
    col3 char(7)) 

Whenever you insert or update a row, Adaptive Server timestamps it by automatically assigning a unique varbinary value to the timestamp column.





Copyright © 2005. Sybase Inc. All rights reserved. Timestamping an existing table

View this book as PDF