---
title: "How can I get a column details and their data type by using stored procedure in SQL server ?"  
description: "How can I get a column details and their data type by using stored procedure in SQL server ?"  
author: "Anonymous User"  
published: 2019-02-28  
updated: 2019-04-03  
canonical: https://www.mindstick.com/forum/34763/how-can-i-get-a-column-details-and-their-data-type-by-using-stored-procedure-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

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

Please give me a suitable example for it.

## Replies

### Reply by Anonymous User

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
```

\


---

Original Source: https://www.mindstick.com/forum/34763/how-can-i-get-a-column-details-and-their-data-type-by-using-stored-procedure-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.