if not exists(select * from syscolumns where id=object_id('tablename') and name='email') beginalter table tablename add email varchar(30)end
Alter table tablenameadd email varchar(30);
