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 ?

Posted by  Sanat Shukla
 788  View(s)
Ratings:
Rate this:

Please give me a suitable example for it. 

  1. Aditya Kumar Patel
    Aditya Kumar Patel
    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

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