MS SQL Add Column

Today I Googled

ms sql script add column

What I was Doing

While changing the schema to a db table, I wanted to be able to communicate my changes easily to my co-workers for their dev environments. Rather than just tell them the steps to follow in SQL Server Management Studio, it would be more efficient to have a query that did the work for me and others.

This would also make it easy to make the change in production by removing the chance for human error with the added bonus of having a record of exactly what change was made.

Solution

I avoided the first link to w3chools and went right to the Microsoft Developer Network documentation.