怎么查询一个table是不是这个库里面的

[cryingboy]

rt!!!

[Chiff]

select * from databasename..sysobjects where name = tablename and xtype = 'U'

[pengdali]

if exists(select 1 from sysobjects where xtype='u' and name='表名')
select 1
else
select 2