Obtain a List of Columns From a Stored Procedure

Obtain a List of Columns From a Stored Procedure

Can I get a list of the columns and datatypes that are returned from a stored procedure without executing the procedure?

There’s no way of doing this using the system tables directly. You could write a program that uses the sysobjects table to query out stored procedures and then get the associated text for the stored procedure from the syscomments table. You would then have to parse through the text and retrieve the column names. It could be done, but you would have to account for SELECT * and any other permutations of the SELECT statement.

See also  11 Effective Keyword Research Tools and Techniques

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist