请教各位大虾如何查出一个表中有unicode制约的字段？

[shan1119]

如题，谢谢!

[talantlee]

sp_help '表名'

[shan1119]

不对啊,得到
myTable1 dbo user table 2005/04/21 13:51:39
我想要的是表sysobjects中xtype='UQ'的字段的名字

[shan1119]

没人回答了吗？
我写的很麻烦,请高手给指点指点
SELECT a.name
FROM syscolumns a INNER JOIN
sysobjects b ON b.name = 'myTable2' AND b.id = a.id INNER JOIN
sysobjects c ON c.parent_obj = b.id AND c.xtype = 'UQ' INNER JOIN
sysindexes d ON d.name = c.name AND d.id = c.parent_obj INNER JOIN
sysindexkeys e ON e.indid = d.indid AND e.colid = a.colid AND e.id = a.id
谢谢!! 期待好的写法