-- 믿을수 없으면 믿을 수 있게 메타데이터 정보를 갱신해 줍시다
use tempdb go drop table tblx drop proc usp_proctest create procedure usp_proctest as select * from tblx go exec sp_depends usp_proctest create table tblx (SomeCol int) exec sp_depends tblx exec sp_refreshsqlmodule 'usp_proctest' exec sp_depends tblx
Comment 3
-
쓸만한게없네(윤선식)
2013.05.03 15:43
-
주디아줌마
2013.05.06 15:00
굿.. 형님
-
열이
2013.05.07 10:30
-- 오브젝트 종속성 확인 참조개체 확인 2005 방식이 더 많이 나옴. 2000 방식은 일부 누락됨.
-- 2000 over
exec sp_depends MyTable-- 2005 over
SELECT OBJECT_SCHEMA_NAME ( referencing_id ) AS referencing_schema_name,
OBJECT_NAME(referencing_id) AS referencing_entity_name,
o.type_desc AS referencing_desciption,
COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id,
referencing_class_desc, referenced_class_desc,
referenced_server_name, referenced_database_name, referenced_schema_name,
referenced_entity_name,
COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name,
is_caller_dependent, is_ambiguous
FROM sys.sql_expression_dependencies AS sed
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id
WHERE referenced_id = OBJECT_ID(N'MyTable');
sp_helptext 도 refresh되었음 행복했을 듯 한.