T-SQL "timestamp" overwrites a data column of type "rowversion"

I use Miscrosoft SQL Server 2012 and because this article says:

Timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new developments and plan to change applications that currently use this feature.

I decided to use the "rowversion" column instead of the "timestamp" column. So, I created the following table:

CREATE TABLE [dbo].[TestTable]
(
     [Col001] [INT] NOT NULL
    ,[Col002] [CHAR](2) NOT NULL
     ...
    ,[Col00N]  [DATETIME2] NOT NULL
    ,[RowVersionID] [ROWVERSION] NOT NULL
    ,CONSTRAINT [PK_ProtoSurveyGlobalizationChanges_RowVersionID] PRIMARY KEY CLUSTERED 
     (
        [RowVersionID] ASC
     )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 
) ON [PRIMARY]

And everything was fine until I pressed the ALT + F1 combination, which gives me information about my table (for example, the details of the columns), and I saw that the column "RowVersionID" has a label with the type "timestamp".

, , , " " SQL Server Management Studio 2012, " SQL" :

[RowVersionID] [timestamp] NOT NULL

, , "timestamp" , - ?

+5
2

, ( ), .

, - , , timestamp , , SQL Server, timestamp.

+9

rowversion timestamp. .

timestamp rowversion . DDL rowversion , .

.

, timestamp ISO. , .

rowversion. timestamp , , .

+5

All Articles