约束有关问题_Sql Server

约束问题？
SELECT
t.name AS table_name,
o.name AS constraint_name,
o.type_desc AS type_desc,
--OBJECT_DEFINITION(o.object_id),
c.name AS column_name
-- ty.name AS type_name
FROM sys.tables AS t
JOIN sys.columns AS c
ON t.object_id=c.object_id
-- JOIN sys.types AS ty
--ON c.system_type_id=ty.system_type_id
JOIN sys.objects AS o
ON t.object_id=o.parent_object_id
AND o.type_desc LIKE '%_CONSTRAINT'
ORDER BY table_name
这个查到的主键约束显示所有键都是，有没有跟好的语句？

------解决方案--------------------

SQL code

SELECT  OBJECT_NAME(parent_obj) tname , a.name AS indexname,b.name as columnname    FROM    sys.sysobjects a inner join sys.syscolumns b on a.parent_obj=b.id    WHERE   a.xtype IN ( 'pk', 'uq' )                AND OBJECT_NAME(parent_obj) = '表名' and b.name='列名'
------解决方案--------------------
SQL codeSELECT  OBJECT_NAME(parent_obj) tname ,        a.name AS indexname ,        b.name AS columnnameFROM    sys.sysobjects a        INNER JOIN sys.syscolumns b ON a.parent_obj = b.idWHERE   a.xtype IN ( 'pk', 'uq' )        AND OBJECT_NAME(parent_obj) IN ( SELECT DISTINCT                                                name                                         FROM   sys.tables )--and b.name='列名'