Developers can use SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer to add new columns to a table. When developers open a table in Table Designer, they see all of its currently defined columns as well as a blank row at the bottom of the table definition grid. They can add columns either in the blank row or they can insert them between existing rows, by following the next steps:
1. In Object Explorer, right-click the table to which they want to add columns and choose Design (Modify in SP1 or earlier).
Table Designer opens with the cursor placed in the first blank cell in the Column Name column. They can also right-click a row in the table and select Insert Column from the shortcut menu. A blank column row is inserted.
2. In the Column Name column, type the column name in the cell. The column name is a required value.
3. Press the TAB key to go to the Data Type cell and select a data type from the dropdown. This too is a required value, and will be assigned the default value if they don’t choose one.
4. Continue to define any other column properties in the Column Properties tab.