Azure SQL Server中缺少存储过程[sys].[sp_mshelpcolumns] [英] The stored procedure [sys].[sp_mshelpcolumns] is missing in azure SQL server

问题描述

**我的问题**

Azure SQL服务器中缺少存储过程[sys].[sp_MShelpcolumns].


**我的查询**

1.我们是否应该在Azure SQL Server上创建此SP?
2.还是存在于其他名称或位置?
3.还是我们在Azure SQL Server中具有等效的SP?

请对此提出建议.

谢谢
安东尼

我尝试过的事情:

试图在Azure sql服务器中执行SP [sys].[sp_MShelpcolumns].我收到以下错误消息

Hi,

**My Problem**

The stored procedure [sys].[sp_MShelpcolumns] is missing in Azure SQL server.


**My Query**

1. Should we be creating this SP on the Azure SQL Server?
2. Or is it existing in another name or another location?
3. Or do we have am equivalent SP in Azure SQL Server?

Please give suggestion on this.

Thanks
Antoni

What I have tried:

Tried to execute the SP [sys].[sp_MShelpcolumns] in Azure sql server . I get below error message

g 2760, Level 16, State 1, Procedure sp_MShelpcolumns, Line 8
The specified schema name "sys" either does not exist or you do not have permission to use it.

推荐答案

Azure中的等效项是； sp_columns(Transact- SQL)| Microsoft文档 [ sp_help(Transact-SQL)| Microsoft文档 [

The equivalent in Azure is; sp_columns (Transact-SQL) | Microsoft Docs[^] OR sp_help (Transact-SQL) | Microsoft Docs[^] - the latter returns multiple result sets depending on what the object identified.
BUT the error you are receiving suggests that you do not have access to the sys schema - this can be confirmed by querying the schema directly using;

SELECT * FROM sys.tables

. br/> 注意:存储过程sp_MSHelpColumns被视为未记录的存储过程，不应用于查询目录

亲切的问候

for instance.
NOTE: The stored procedure sp_MSHelpColumns is considered an undocumented stored procedure and should not be used to query the catalogs

Kind Regards

这篇关于Azure SQL Server中缺少存储过程[sys].[sp_mshelpcolumns]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！