8

Is rowversion not a valid data type in Microsoft SQL Server 2008 R2?

Bonus Chatter

i'm trying to add a rowversion column to a table:

enter image description here

But when i try to leave the "Data Type" column, SQL Server Management Studio complains

Invalid data type.

enter image description here

and insists that i pick a different data type:

enter image description here

How do i make a column rowversion when rowversion is not a valid data type?

Bonus Viewing

enter image description here

Bonus Reading

rowversion (Transact-SQL)

timestamp is the synonym for the rowversion data type and is subject to the behavior of data type synonyms. In DDL statements, use rowversion instead of timestamp wherever possible. For more information, see Data Type Synonyms (Transact-SQL).

The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Additional Bonus Chatter

Ian Boyd
  • 220,884
  • 228
  • 805
  • 1,125

3 Answers3

5

If it's any help, the Visual Studio 2012 SQL Server Object Explorer designer does have the rowversion option (even though the VS 2012 Server Explorer Data Connections designer doesn't either).

enter image description here

WDO
  • 261
  • 3
  • 4
5

SQL Server 2008 R2 accepts ROWVERSION as datatype for columns in CREATE TABLE statements, however the SSMS seems to lag behind and the designer refuses to accept the input.

Mithrandir
  • 22,998
  • 5
  • 41
  • 61
  • 2
    *You think you are wise, Mithrandir. Yet for all your subtleties, you have not wisdom. Do you think the eyes of Microsoft are blind?* Also /facepalm at Microsoft (http://connect.microsoft.com/SQLServer/feedback/details/352733/ssms-should-not-given-an-error-when-newsequentialid-used-as-a-default-value-or-binding) – Ian Boyd Jan 23 '12 at 20:42
  • 1
    I know this is old but if anyone else comes here looking for an answer, however, I just wanted to leave a comment about what happens if you now go into the table via design view after creating it via TSQL statements.... The IDE will auto convert the column back to `timestamp` data type. No warnings no errors, just an auto convert. – famousKaneis Oct 06 '15 at 19:10
2

"The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. " so i think timestamp =rowversion .so you dont need rowversion.

Aram Farzin
  • 31
  • 2