Updating columns with the rowguidcol property is not allowed the touch of satan online dating
If the new column does not allow null values and the table is not empty, a DEFAULT definition must be added with the new column, and the new column automatically loads with the default value in the new columns in each existing row.
ALTER COLUMN Specifies that the named column is to be changed or altered.
Modifies a table definition by altering, adding, or dropping columns and constraints, reassigning and rebuilding partitions, or disabling or enabling constraints and triggers.
Transact-SQL Syntax Conventions Is the name of the table to be altered.
For more information, see CREATE TABLE (Transact-SQL).
[ ROWGUIDCOL ] Applies to: SQL Server 2008 through SQL Server 2017 and Azure SQL Database.