Home / Software / Tips and Tricks / How to list column Name and Type of SQL Server Table ?

How to list column Name and Type of SQL Server Table ?

Updated:  04/04/2012 07:04 AM
Author:  Shiju Mathews

Status:    Resolved.


The system table “[information_schema].[columns]” will store the details about the all the tables. A select query on this table will give you the required information.

The following query will give Column Name, Data Type and Maximum Length for the specified table.