1.添加字段
if
not
exists
(
select
*
from
syscolumns
where
id=object_id(
'tablename'
)
and
name
=
'email'
)
begin
alter
table
tablename
add
email
varchar
(30)
end
2.删除字段
ALTER TABLE tablename DROP COLUMN email;
email----->添加字段名
tablename----->表名