SQL Server 2008 查询表字段相关属性

select
 c.name as cname,c.prec AS Prec,c.isnullable AS isnullable,
 [IsPk]=case when exists(SELECT 1FROM sysobjects s where xtype='PK' and parent_obj=c.id and name in (
        SELECT name FROM sysindexes WHERE indid in(SELECT indid FROM sysindexkeys WHERE id
 = c.id AND colid=c.colid)))then '1' else '0' end,
[defaultval]=isnull(e.text,''),
t.name as tname
 ,(select value from sys.extended_properties as ex where ex.major_id
 = c.id and ex.minor_id
 = c.colid) as notes
from
 syscolumns as c inner join sys.tables as ta on c.id=ta.object_id
 inner join  (select name,system_type_id from sys.types where name<>'sysname')as t on c.xtype=t.system_type_id
 left join syscomments
 e on c.cdefault=e.id
where
 ta.name='TFunction' order by c.colid