This is a very simple question to which I haven't yet found an
answer. I've just started working with SQL Server, and would like
to print out a report listing the properties (Ie. field types, length,
description, etc.) of all of my tables. How do I do this
Thanks in advance.
SQL table properties reporting
Hot Topic
- How to sort that does not include duplicates in display?
- Fuzzy Grouping error when progress: Finding similar records
- TableCollection does not contain any table?
- Error in Data-Driven Subscription
- Automatically Fire Trigger Or Procedure in sql server 2000
- Object Explorer
- Running a package in C#
- Convert between ASCII and EBCDIC
- Using Triggers to track Changes in a single Audit table
- SSIS Access from SQL Server Management Studio
SQL Server
- Matrix Subtotals
- Login failed
- Problem with nested INSERT EXEC
- How to register remote server? Authentication method is grayed out!
- Textbox rotation or display horizontal vs vertical
- Query/View Question
- Error 87 while installing SQL Server 2005
- Express Manager for Sept CTP
- can't find xp_sqlagent_proxy_account procedure
- Creating an update trigger for a multi-table view
SQL table properties reporting
CourtJesterG
There are probably far better ways to do this, and (disclaimer) I don't think MS would recommend querying the systems tables because they may be subject to change (which would break your code); but here it is:
SELECT
[sysobjects].name, [syscolumns].name, [systypes].[name], [syscolumns].[length] FROM [dbo].[systypes] inner join [syscolumns] on [syscolumns].xtype = [systypes].xtype inner join [sysobjects] on [sysobjects].id = [syscolumns].id