INFORMATION_SCHEMA.COLUMNS,取所有表PK

請參考來源
 --
取所有表PK

select TABLE_NAME, COLUMN_NAME   from INFORMATION_SCHEMA .KEY_COLUMN_USAGE  where TABLE_NAME<>''  order by TABLE_NAME,COLUMN_NAME