|
Category: SQL Server
view more software Tips and Tricks
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. |