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:67

Points:475
 410  View(s)
Ratings:
Rate this:

Please give me a suitable example for it. 

  1. Post:282

    Points:2010
    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 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved