判断字段是否存在: if not exists(select * from syscolumns where id=object_id('temphlxf') and name='czy') begin alter table temphlxf add czy varchar(50) not null end GO 判断主键是否存在: IF EXISTS (select * from sysobjects where parent_obj=object_id(N'temphlxf') and name='pk_temphlxf' and xtype='PK') BEGIN ALTER TABLE temphlxf drop Constraint pk_temphlxf END GO 判断某个字段是否具有not null约束: if exists (select * from syscolumns where id = OBJECT_ID('temphlxf') and name = 'czy' and isnullable=1) begin alter table temphlxf alter column czy varchar(50) not null end GO