How add new column to the table in SQL Server Management?
Sometimes You would like to add column after created table. But this action may be blocked.
To the testing I created database BazaTest
and table of testowa
name. At first table contains column of datatype int
and column of name nazwa
of text datatype. Columns will constraint only by null..
After created and saved table, I added to this table column of int
datatype.
Unfortunately, attempt to save this column end to display warning window.
Blocking was missed by writing in properties this column default value.
In this case new column was written.
Another way is check Allow Nulls
check box. In this way the next column of kolejna
name of int
datatype was added.
And it is result: