SQL datatype "rowversion" doesn't actually exist in SQL server - by Richard Brown (CFCU)

Status : 


Sign in
to vote
ID 1051602 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 12/10/2014 12:24:00 PM
Access Restriction Public


According to the documentation (http://msdn.microsoft.com/en-us/library/ms182776.aspx) the rowversion datatype exists and the synonym "timestamp" is acceptable for backwards compatibility but it is deprecated and any DDL statements should be updated to use rowversion instead of timestamp. However, the actual name of the type in sys.types is still displaying as "timestamp" (as of SQL 2012 SP1 at least, I assume the same is true in SQL 2014), and even if a column is created using rowversion any scripts that generate the table will use timestamp. Also, the "Design Table" GUI within SSMS only has timestamp available in the dropdown list and not rowversion.

The deprecation of using the name "timestamp" is noted as far back as SQL 2008 version notes, but technically rowversion has been and remains the synonym and timestamp is the actual datatype name. If the functionality is not going to be corrected, then the documentation should at least be updated to accurately describe how the datatype is expressed in the system.
Sign in to post a comment.