sqlserver 查询存储过程中的使用和表有的字段

SELECT DISTINCT
    o.name,
    o.xtype
FROM
    sysobjects o,
    syscomments s
WHERE
    o.id = s.id
AND o.xtype IN ('p', 'v') 
AND s.text LIKE '%RecopID%'

select b.name as tablename,a.name as columnname,c.name as typename,a.max_length as typelength

from sys.columns a inner join sys.tables b on b.object_id=a.object_id

inner join sys.types c on c.system_type_id=a.system_type_id

where a.name='RecopID'

order by b.name,a.column_id