在存储过程或函数中查找表 [英] Find table in store procedure or function

问题描述

示例:我想删除一个表，但我不知道该表可用于存储还是用作功能?在存储过程或功能中如何使用表?谢谢！

Exemple : I want to delete a table but I don''t known it can be use in store or funtion? How can known a table is used in store procedure or funtion? Thanks!

推荐答案

有两种找到方法:
第一:

Hi,
There is two ways to find this:
First:

SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%tablename%'

第二:

Second:

SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%tablename%'

--Amit

--Amit

请参考此线程.
搜索存储过程 [

Hi,
Refer this thread.
Searching The Stored procedure[^]

这篇关于在存储过程或函数中查找表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！