SQL 判断表和临时表时否存在

判断 临时表#tmp是否存在

if(object_id('tempdb..#tmp') is not null)
begin
drop table #tmp
end

1）判断 表DepartmentInfo是否存在

if object_id('DepartmentInfo') is null
begin
 select '不存在'
end
else
begin
 select '存在'
end
2）判断表'LC_Department是否存在

if not exists (select * from sysobjects where [name] = 'LC_Department' and xtype='U')
begin
--这里创建表
select '不存在'
end
else
begin
select '存在'
end