Add a column of zeros to table sql server

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/10342818/add-a-column-of-zeros-to-table-sql-server

Answer 1

If I recall correctly, it should be something like:

ALTER TABLE table_name 
ADD extra REAL DEFAULT 0

See: http://msdn.microsoft.com/en-us/library/ms190273.aspx

See: Add a column with a default value to an existing table in SQL Server