Add a column with a default value to an existing table in SQL Server On 29th Aug 20187th Sep 2018 By Upendra RawatIn SQL Server ALTER TABLE TABLENAME ADD ColumnName int NOT NULL DEFAULT(1) GO Share this: Share on X (Opens in new window) X Share on Facebook (Opens in new window) Facebook Like Loading... Related
Dot Net Tricks 