T-SQL로 테이블, 컬럼명 조회하기

select  a.name as table_name,
           b.name as column_name,
           c.name +' (' + cast(b.length as varchar) + ')' as column_type,
           'Rs.Fields(' + cast((b.colid - 1) as varchar)+ ')' as sorting_order
from      dbo.sysobjects a, dbo.syscolumns b, dbo.systypes c
where   a.id = b.id
and      a.name like 'tbl_%'
and      b.xtype = c.xtype
order by a.name, colid 

[출처] T-SQL로 테이블, 컬럼명 조회하기|작성자 필립박