＋设为首页 ＋添加到收藏夹
如题？
if exists (select * from sysobjects where name=you table and xtype=U)
begin
...........
end
if object_id(表名) is not null
print Yes
else
print No
exists (select * from sysobjects where name=tablename and xtype=U)
if exists (select * from sysobjects where name=tablename and xtype=U)
print 表存在
else
print 表不存在
if exists(select * from INFORMATION_SCHEMA.TABLES where table_name=tablename)
print exist
else
print no exist
再给你一个方法
if exists (select 1 from sysobjects where name=tablename and xtype=U)
begin
print exists
end
else
begin
print not exists
end
