To add a new column to your current table, you would alter the table and add a new column.
Intuitively.
ALTER table_name
ADD column_name type
Above commend when executed would add a new column with name
column_name
in the table named
table_name
. Alter these values (
table_name
,
column_name
) to suit your own requirements. For more on this, please read
https://msdn.microsoft.com/en-us/library/ms190273.aspx[
^]