Add column, with default value, to existing table in SQL Server

Question

AVADHESH PATEL · Answer

Hi Ashish!You can try as belowALTER TABLE {TABLENAME}and ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}and CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}I hope it resolve your problem

forum

Add column, with default value, to existing table in SQL Server

Anonymous User

Can you answer this question?

1 Answers

Liked By