#139 SQL Server 2005 Table comments includes field comments

[Anonymous]

selectTableCommentsSql in mssql05.properties and mssql05-jtds.properties includes both table and field comments. On some tables, if you have any field comments, you'll get the comment for a random mfield instead of the table's.

To correct this, modify the SQL as follows ( add 'AND s.minor_id=0', which limits it to Table descriptions only)

SELECT i_s.TABLE_NAME, s.value AS comments FROM INFORMATION_SCHEMA.Tables i_s
INNER JOIN sys.extended_properties s ON s.major_id = OBJECT_ID(i_s.table_catalog + '..' + i_s.table_name)
WHERE s.class = 1 AND s.name = 'MS_Description' AND s.minor_id=0

[John Currier]

Thanks for figuring it out. It's resolved in rev 650. Note that mssql05-jtds.properties already included the minor_id=0 criteria.

John