Toad World® Forums

MSSQL data type rowversion


#1

Hi,

could you support an MSSQL data type rowversion?

Here is a short comment from MSSQL 2005 help:

The Transact-SQL timestamp data type is different from the timestamp data type defined in the SQL-2003 standard. The SQL-2003 timestamp data type is equivalent to the Transact-SQL datetime data type.

rowversion is the synonym for the timestamp data type and is subject to the behavior of data type synonyms. In DDL statements, use rowversion instead of timestamp wherever possible.

Thank you.

With the best regards

Lada


#2

Hi Lada,

Rowversion data type is supported in TDM for MS SQL Server 2008. Rowversion is also generated instead of data type timestamp for this db.

In MS SQL Server 2005 (in comparison with v. 2008), rowversion is only synonym of timestamp data type.
Nevertheless, during SQL/DDL generation (F9), you can click the Detail Settings tab and select the Generate Data Type TIMESTAMP As ROWVERSION checkbox.

Hope this will help a little.

Have a nice day.

Regards,

Vladka


#3

Hi Vladka,

thank you.
It has helped.

Have a nice day too,

Lada