查询数据库各表与其主键
SQLserver
查询数据库各表与其主键
select a.name,max(a.pk1) 'pk1',max(a.pk2) 'pk2',max(a.pk3) 'pk3',max(a.pk4) 'pk4'
from (
Select
t.name,
case when k.keyno=1 then col_name(t.object_id,k.colid) else NULL end as 'pk1',
case when k.keyno=2 then col_name(t....
原创
2021-04-15 16:09:31 ·
334 阅读 ·
0 评论