Table Description

[Sobhan Vezzu]

Hi All,
In SQL Server how can I get the descriptions of tables in a
database?

From MSDN help I could find a way to get the description of columns
using the following extended property

SELECT *
FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'Reports', 'column', default)

Thanks
Regards
Sobhan

[Erland Sommarskog]

Sobhan Vezzu (so****@eudoramail.com) writes:

In SQL Server how can I get the descriptions of tables in a
database?

From MSDN help I could find a way to get the description of columns
using the following extended property

SELECT *
FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table',
'Reports', 'column', default)

You should be able to do this with fn_listextendedproperty as well.
(Provided that any extended properties have been entered for the tables!)
As I can read in Books Online, you specivy the penultimate argument as
NULL.

Please see Books Online for details.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp