SQL Server - 查询系统对象
我注意到，当我查询 dbo.sysobjects 时，为了确定我的数据库中的所有对象，它还会选取名称以syncobj_"开头的所有系统视图.它们的 xtype 为V"，除了检查视图名称外，我似乎无法知道这些是系统视图，而不是我自己的视图.还有其他方法吗?我想从我正在创建的查询中排除这些.
I notice that when I query dbo.sysobjects, to determine all the objects in my database, it also picks up all system views whose name starts with 'syncobj_'. These have an xtype of 'V' and there doesn't appear to be any way I can know these are system views, and not my own, except by examining the name of the view. Is there some other way? I would like to exclude these from a query I'm in the process of creating.
推荐答案
参见 OBJECTPROPERTY:
IsMSShipped
IsMSShipped
任何模式范围的对象
在安装 SQL Server 期间创建的对象.1 = 真 0 = 假
Object created during installation of SQL Server. 1 = True 0 = False
像这样使用它:
SELECT * from sysobjects where OBJECTPROPERTY(ID,N'IsMSShipped') = 0
虽然它的文档有点偏离 - 它还可以帮助您排除by"添加的其他对象.SQL Server 稍后也 - 例如任何与复制相关的对象也被视为 IsMSShipped.
It's documentation is a bit off though - it also assists you with excluding other objects added "by" SQL Server at a later date also - e.g. any replication related objects are also considered to be IsMSShipped.
相关文章