SQL Server Error Code – 4901 alter table only allows columns to be ad

In this blog post, you’ll learn more about the SQL Server Error Code 4901 and the error message description that is shown

SQL Server Error Code

4901

SQL Server Error Description for the Code :4901

ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column ‘%.*ls’ cannot be added to non-empty table ‘%.*ls’ because it does not satisfy these conditions.