---
title: "How to returns columns and column information pertaining to the designated table?"  
description: "How to returns columns and column information pertaining to the designated table?"  
author: "Anonymous User"  
published: 2012-02-13  
updated: 2020-09-22  
canonical: https://www.mindstick.com/interview/1388/how-to-returns-columns-and-column-information-pertaining-to-the-designated-table  
category: "mysql"  
tags: ["mysql"]  
reading_time: 1 minute  

---

# How to returns columns and column information pertaining to the designated table?

mysql> show columns from table_name;

## Answers

### Answer by Anonymous User

mysql> show columns from table_name;


---

Original Source: https://www.mindstick.com/interview/1388/how-to-returns-columns-and-column-information-pertaining-to-the-designated-table

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