select
col.table_catalog,
col.table_name,
col.column_name,
obj2.name as SP_Name,
obj2.id as SP_ID
from sysdepends dep, sysobjects obj, sysobjects obj2, information_schema.columns col
where dep.depid = obj.id
and dep.id = obj2.id
and obj.name = col.table_name
and col.column_name = 'ssn'
and obj2.xtype='P'
group by col.table_catalog, col.table_name, col.column_name, obj2.name, obj2.id
etc...
sp_tables
-- 테이블 리스트
select * from information_schema.tables
-- 컬럼 상세 정보
select * from information_schema.columns
where table_name = '테이블명'
order by 5
Leave your greetings.