Sunday, 15 February 2015

SQL Server : trying to add non-null column to an existing table (table is empty) -


I'm trying to add a new column to my exiting table, but I want to insert non-empty columns I am trying to

I understand that this will be an issue for the existing database with so many data, but there is no data in my database so why am I confused as to this error.

Is there an easy solution (I do not want to add default value)

You have two options, feed it to a default value, or add fields without a non-realistic obstacle, then change the table later, so that you can add a non-null barrier after being paranoid in the ground.

No comments:

Post a Comment