查詢sql server tables names/columns names

select *
  from bigsun_human.sys.tables;

select *
  from bigsun_human.sys.columns;


甚麼column在甚麼table
select b.name table_name,a.name column_name
  from  bigsun_human.sys.columns a,bigsun_human.sys.tables b
 where a.object_id = b.object_id