How to add a Computed Checksum Column to a SQL Server Table

To add a Computed Column as CHECKSUM of another column in a SQL Server Table, use the following code:

ALTER TABLE Table_Name
ADD Checksum_Column_Name AS CHECKSUM(Column_Name);
GO

To add a Computed Column as CHECKSUM of multiple columns in a SQL Server Table, use the following code:

ALTER TABLE Table_Name
ADD Checksum_Column_Name AS CHECKSUM(Column1, Column2, Column3,...);
GO

add_checksum_column

You can see that the Checksum column is added to the table:

checksum_column

To see the specification of the computed checksum column, right click on the table in the Object Explorer, choose 'Design':

checksum_column_table_design

...and click on the 'Column Name' to see 'Computed Column Specification' in the 'Column Details':

computed_column_specification