CJayMead's SQL Server, Endeca, MS Office, and Entrinsik's Informer Help

Month: November 2008

SQL: List of table columns, with data types

CJayMead

Thursday, 6th November, 2008

SQL Server, Transact-SQL

The Transact-SQL query in this post returns the table name, column name, data type, and maximum length. This is useful when producing database documentation

Characters Coalesce Columns Crop Database Database Developer Database Files Data Types Dates & Times Default Development Email Endeca Error Field Function Hardware Indexes Informer Installation IsNull Management Studio Microsoft Certification Microsoft Excel Microsoft Office Microsoft Word MVC Null Optimization Permissions Record Counts Relationships Replace search SQL Server Stored Procedure Tables Tagged Text Third Party Transact SQL Visual Basic Visual Studio Windows WordPress

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

CJayMead's SQL Server, Endeca, MS Office Help © 2018