- 判断列是否存在 语法:if exists(select * from syscolumns where id=object_id('表名') and name='列名')
- 判断存储过程是否存在
①if exists (select * from sysobjects where id = object_id(N'[存储过程名]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [存储过程名]
②IF EXISTS ( SELECT * FROM SYS.OBJECTS WHERE TYPE='P' AND NAME&#