When we add a column with default constraint will the Ct version changes or not

use prism
/* Creating a table*/
Create table dbo.Prismtest
(
Id int primary key identity(1,1),
[Name] Varchar(10))

alter table dbo.Prismtest add [Address2] varchar(100) default('abc') not null 

select * from dbo.prismtest

insert into dbo.Prismtest ([Name]) values ('def' ) 

select ct.* FROM changetable(changes dbo.Prismtest,1 ) as ct
 LEFT JOIN dbo.Prismtest a on a.id=ct.id  -- 54067710    /Checking the data in CT table*/

select change_tracking_Current_version()  -- 54067711 
/* Here check the CT version is getting changed or not  -- Important */ 

Alter table dbo.Prismtest
Enable change_tracking
WITH (TRACK_COLUMNS_UPDATED = OFF);

Comments

Popular posts from this blog

CT and CDC Info