Give a link some love! Login and vote now.
By ScottG
via sqlservercurry.com
Published: Aug 11 2009 / 12:31
While programming a Data Layer, I often refer to the database and its tables for the datatypes and its sizes. It’s real handy to be able to print a list of the properties of the columns. Here’s a query that will help you fetch the DataType and Size Of all Columns of All Tables in a SQL Server 2005/2008 Database.



Add your comment