sqlserver 2005 sql脚本判断数据表是否已创建

这里记录下来主要是方便自己以后测试,通过print打印结果.

DECLARE @t1 NVARCHAR(100) if not exists(select * from sysobjects where name = 'T_flow_step_def') begin select @t1 = 'yes' print @t1; end else begin select @t1 = 'no' print @t1; end