بدست آوردن Description جداول

[SReza1]

من در SQL 2000 با این دستور Description جدوال را می خوندم.

select sysproperties.value , sysobjects.id , sysobjects.name from sysobjects
inner join sysproperties on sysobjects.id = sysproperties.id
where sysobjects.xtype in ('U') and sysproperties.type = 3 order by 1


ولی در 2008 نمیدونم چه دستوری داره . کسی هست بدونه؟

[SReza1]

جوابشو پیدا کردم


select *
FROM INFORMATION_SCHEMA.TABLES tbl
LEFT JOIN sys.extended_properties prop ON prop.major_id = object_id(tbl.table_schema + '.' + tbl.table_name)
AND prop.minor_id = 0 AND prop.name = 'MS_Description'

[minaalamshahi]

SELECT sys.columns.name AS ColumnName, sys.types.name AS ColumnType,
(SELECT value
FROM sys.extended_properties
WHERE (major_id = sys.columns.object_id) AND (minor_id = sys.columns.column_id) AND (class = 1)) AS ColumnDescription, sys.columns.max_length,
sys.columns.is_identity, sys.columns.is_nullable
FROM sys.columns INNER JOIN
sys.tables ON sys.columns.object_id = sys.tables.object_id INNER JOIN
sys.types ON sys.columns.user_type_id = sys.types.user_type_id INNER JOIN
sys.schemas ON sys.tables.schema_id = sys.schemas.schema_id
WHERE (sys.tables.name = @SourceName) AND (sys.schemas.name = 'dbo')