Home > DeveloperSection > Forums > How can I get a column details and their data type by using stored procedure in SQL server ?
 Ask Question

How can I get a column details and their data type by using stored procedure in SQL server ?

Total Post:87

Points:615
 537  View(s)
Ratings:
Rate this:

Please give me a suitable example for it. 

  1. Post:286

    Points:2044
    Re: How can I get a column details and their data type by using stored procedure in SQL server ?

    If you want to get Stored Procedure Result Column details and datatype Types use the following Script: 

    EXEC sp_describe_first_result_set N'YourStoredProcedureName'

    If you want to get table Column details and datatype Types or Name use the following Script: 

    exec sp_columns yourtablename


Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved