Yes. <pre lang="sql">ALTER TABLE MyTable ADD newIntegerColumnName INT DEFAULT 666</pre> It's a good idea to provide a default value if you already have existing rows.
ALTER TABLE TableName ADD ColumnName DataType
EXEC ('alter table tb1 add col1 varchar(1) null') EXEC ('update tb1 set col1 = ''Y''')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)