1.視圖查詢/及内容查找(可查裏面鏈接外部服務器的database,或者使用別的database)
SELECT sys.sysobjects.name, sys.syscomments.text, sys.sysobjects.type
FROM sys.sysobjects INNER JOIN syscomments
ON sys.sysobjects.id = sys.syscomments.id
WHERE type = 'V'
ORDER BY sys.sysobjects.NAME
可在where 加入你需要查找的條件如 text like '%xxx.xxx%'
2.存儲過程及内容查找(可查裏面鏈接外部服務器的database,或者使用別的database)
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%xxx%'
AND ROUTINE_TYPE='xxx'
ORDER BY ROUTINE_NAME