---
title: "find the all column with schema for any table in sql server"  
description: "find the all column with schema for any table in sql server"  
author: "Varun Agrawal"  
published: 2011-03-25  
updated: 2013-04-09  
canonical: https://www.mindstick.com/forum/205/find-the-all-column-with-schema-for-any-table-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# find the all column with schema for any table in sql server

How to find all [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) with [schema](https://www.mindstick.com/articles/1844/how-schema-markup-useful-in-serp) for any [table in sql](https://www.mindstick.com/forum/160541/how-to-create-pivot-table-in-sql-server) server.\
please give the example.\
thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)

## Replies

### Reply by Shankar M

Hi Varun,\
Alternatively you can try,\
SP_HELP EMP in [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) Server \
Here EMP is the table name\
Thanks,Shankar

### Reply by Anonymous User

Hi Varun,

You can try this to find all column with schema for any [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) in [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server).\

```
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’table_name’
```


---

Original Source: https://www.mindstick.com/forum/205/find-the-all-column-with-schema-for-any-table-in-sql-server

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