Category: SQL Server
view more software Tips and Tricks
Updated: 04/04/2012 07:04 AM
Author: Shiju Mathews
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.