SQL Server - 为 sysobjects 返回 SCHEMA [英] SQL Server - Return SCHEMA for sysobjects

问题描述

在 sysobjects 上进行选择时如何获得 SCHEMA?

How to I get the SCHEMA when doing a select on sysobjects?

我正在修改一个名为 SearchObjectsForText 的存储过程，它只返回名称，但我还想包括 SCHEMA.

I am modifing a stored procedure called SearchObjectsForText which returns only the Name but I would also like to include the SCHEMA.

现在它正在做类似的事情:

Right now it is doing something similar to this:

SELECT DISTINCT name
FROM sysobjects

我想知道需要连接哪些表才能返回每个名称"的 SCHEME.

I would like to know what tables need to be joined to return the SCHEME for each 'name'.

推荐答案

如果您指的是 SQL Server 2005 或更高版本，请使用 sys.objects 而不是 sysobjects:

If you mean SQL Server 2005 or higher, use sys.objects instead of sysobjects:

SELECT  sys.objects.name, sys.schemas.name AS schema_name
FROM    sys.objects 
INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id

2005 年引入了模式.直到 2000 年，用户等于模式.SQL Server 2000 的相同查询:

2005 introduced schemas. up to 2000, users equaled schemas. The same query for SQL Server 2000:

SELECT  sysusers.name AS OwnerName, sysobjects.name
FROM sysobjects
INNER JOIN sysusers ON sysobjects.uid = sysusers.uid

这篇关于SQL Server - 为 sysobjects 返回 SCHEMA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！