get a list of table & field from stored procedure

프로시저에 사용된 테이블, 컬럼 리스트 출력

create procedure sp_sp_tbl_col_list

as 

select  

         bb.name           as spName

,        cc.name           as tableName

,        dd.COLUMN_NAME    as columnName

,        dd.DATA_TYPE      as dataType

,        dd.IS_NULLABLE    as isNullable

,        ISNULL(

                  ISNULL(CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH)

                            ,'( '+CONVERT(VARCHAR,NUMERIC_PRECISION)+', '+CONVERT(VARCHAR,NUMERIC_SCALE)+' )')

                  , DATA_TYPE )     as dataLenth

from sysdepends                    aa

inner join sysobjects      bb

on aa.id = bb.id

inner join sysobjects      cc

on aa.depid = cc.id

left outer join INFORMATION_SCHEMA.COLUMNS dd

on aa.depnumber = dd.ORDINAL_POSITION

where bb.xtype = 'P'

and cc.name = dd.TABLE_NAME

order by 1,2,3