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