请问SQLServer 里如何判断指定的一个数据库里某个表是否存在？

[poptang5]

最好是用存储过程来查找。多谢。

[panjinfu80]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SystemSet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

[$扫地僧$]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

[xeqtr1982]

if exists (select 1 from sysobjects where id=object_id(表名) and xtype='U')

[liangpei2008]

CREATE PROCEDURE TableExist
@tablename varchar(40)
AS
if exists (select 1 from sysobjects where id=object_id(@lastname) and xtype='U')
print 'Exists'+@lastname
else
Print 'Not Exists'+@lastname

[liangpei2008]

修改一下：
CREATE PROCEDURE TableExist
@tablename varchar(40)
AS
if exists (select 1 from sysobjects where id=object_id(@tablename) and xtype='U')
print 'Exists'+@tablename
else
Print 'Not Exists'+@tablename