The stored procedure [sys].[sp_mshelpcolumns] is missing in azure SQL server

Question

0.00/5 (No votes)

See more:

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.

Posted 12-Jun-18 21:16pm

P.Gnanaraj

Updated 13-Jun-18 11:57am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

an0ther1 · Accepted Answer · 2018-06-13T11:59:00

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;

SQL

SELECT * FROM sys.tables

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