SELECT sysproperties.value
FROM syscolumns
INNER JOIN sysproperties ON
syscolumns.id = sysproperties.id and syscolumns.colid = sysproperties.smallid
INNER JOIN sysobjects ON
syscolumns.id = sysobjects.id
WHERE sysobjects.name = '表名' and syscolumns.name = '列名'
在SQL 2000中通过
SELECT c.value FROM sysObjects a, syscolumns b,sysproperties c
WHERE a.[name] = '表名' and a.[id]=b.[id] AND B.[name]='列名' and c.smallid = b.colid