Almost a decade before, I came across a requirement where I needed to add multiple columns in a table with default value. It took a while on that time to figure it out.
I found it in my old SQL Projects repository and thought to share it with you.
— Creating a table and adding a row
CREATE TABLE TestTable1(Id INT, SomeCol VARCHAR(10))
INSERT INTO TestTable1 SELECT 10, ‘abcdefgh‘
— Adding Multiple Columns With Default Values
ALTER TABLE TestTable1
ADD Col1 VARCHAR(100) NOT NULL DEFAULT(‘SomeInformation‘),
Col2 INT NOT NULL DEFAULT(999)
— Retrieve Data from Table
SELECT * FROM TestTable1