ms sql server 查询一个表的字段属性和主键

 
SELECT  sys.columns.name, 
(SELECT name from sys.types where sys.types.system_type_id=sys.columns .system_type_id) as system_type_name,
 sys.columns.max_length, 
sys.columns.is_nullable ,
  'is_pk'=   
(select --c.id, c.name  ,k.colid ,k.keyno  
case when count(*)> 0 then 'true' else 'false' end
 from sysindexes i
 join sysindexkeys k on i.id = k.id and i.indid = k.indid
 join sysobjects o on i.id = o.id
 join syscolumns c on i.id=c.id and k.colid = c.colid
 where o.xtype = 'U'
 and exists(select 1 from sysobjects where  xtype = 'PK'  and name = i.name)
and c.name=sys.columns  .name and c.id=sys.columns  .object_id 
)
from  sys.tables ,sys.columns  
where  sys.tables.name='hr_SalaryRecords' and  sys.tables.object_id =sys.columns .object_id