sql server 牛人，请进！！！

atransformer

知道一个object name 是 updateDatePublish_New3

OBJECT_ID 能得到id, 如何知道这个object是个什么东西？？ table or view or sp or function?

jerryclark

看名字像是replication的

jerryclark

SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[updateDatePublish_New3]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1

google 一下 OBJECTPROPERTY

http://msdn.microsoft.com/en-us/library/ms176105.aspx

atransformer

SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[updateDatePublish_New3]')

works

jerryclark

把上面的‘IsProcedure’，换成IsTable， IsTrigger，等等等等，就可以知道其属性了

jerryclark

光看sysobjects 好像看不出到底是什么类型的object。
还得用OBJECTPROPERTY函数才能确定

atransformer

原帖由 jerryclark 于 2011-10-31 12:58 发表
光看sysobjects 好像看不出到底是什么类型的object。
还得用OBJECTPROPERTY函数才能确定

貌似可以。 有一个column叫 [xtype]

huaxianz

Since version 2005, it's recommended by MS to use system catalogue or dmv/dmf, instead of legacy system functions/sps.

In the context of current database:
select [object_id], [type], [type_desc]
from sys.objects
where [object_id] = ?;