sqlserver 查询获取主键

SELECT  --sysobjects.id objectId ,  
OBJECT_NAME(sysobjects.parent_obj) tableName,  
--sysobjects.name constraintName,   
--sysobjects.xtype AS constraintType,  
syscolumns.name AS columnName  
FROM sysobjects INNER JOIN sysconstraints  
ON  sysobjects.xtype in( 'PK' )   AND   
sysobjects.id = sysconstraints.constid  
inner JOIN syscolumns ON sysconstraints.id = syscolumns.id
WHERE syscolumns.typestat=3

AND  OBJECT_NAME(sysobjects.parent_obj)='CONNECT_CONTRACTUAL_FUTURE_PAYMENTS'

查询数据库中table的主键外键,

网上找得如下,但是结果不对

SELECT syscolumns.*,sysobjects.id objectId--,  
--OBJECT_NAME(sysobjects.parent_obj) tableName,  
--sysobjects.name constraintName,   
--sysobjects.xtype AS constraintType,  
--syscolumns.name AS columnName  
FROM sysobjects INNER JOIN sysconstraints  
ON --sysobjects.xtype in('C', 'F', 'PK', 'UQ', 'D')   AND   
sysobjects.id = sysconstraints.constid  
LEFT OUTER JOIN syscolumns ON sysconstraints.id = syscolumns.id
WHERE OBJECT_NAME(sysobjects.parent_obj)='CONNECT_CONTRACTUAL_FUTURE_PAYMENTS'