×

Loading...
Ad by
Ad by

@Calgary

View OK. SP/Function you can try.

deep_blue(BLUE)
You can accurately find out view name by table name.
SELECT VIEW_NAME FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE WHERE TABLE_NAME= 'Your Table Name'

However, it’s not easy to accurately obtain functions /stored procedures by table name

Anyway, you can try:

DECLARE @TABLE_NAME VARCHAR(100)

SELECT @TABLE_NAME = '%' + 'Your Table Name' + '%'

SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
WHERE (ROUTINE_TYPE = 'FUNCTION' OR ROUTINE_TYPE = ‘PROCEDURE’) AND ROUTINE_DEFINITION LIKE @TABLE_NAME
(#3882621@0)
Last Updated: 2007-8-21
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / Looking for a way to do this in SQL server: given a table name, and would like to know a list of stored procedures/View/Function are using this table. -sunday8(sunday8); 2007-8-21 {10} (#3882373@0)
    Thank you.
    • View OK. SP/Function you can try. -deep_blue(BLUE); 2007-8-21 {533} (#3882621@0)
      You can accurately find out view name by table name.
      SELECT VIEW_NAME FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE WHERE TABLE_NAME= 'Your Table Name'

      However, it’s not easy to accurately obtain functions /stored procedures by table name

      Anyway, you can try:

      DECLARE @TABLE_NAME VARCHAR(100)

      SELECT @TABLE_NAME = '%' + 'Your Table Name' + '%'

      SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
      WHERE (ROUTINE_TYPE = 'FUNCTION' OR ROUTINE_TYPE = ‘PROCEDURE’) AND ROUTINE_DEFINITION LIKE @TABLE_NAME
      • great. the SP/Function seem working but View not..thx. -sunday8(sunday8); 2007-8-21 (#3882808@0)

More Topics

  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
  • 如何在 AWS EC2 实例上构建 WordPress 应用程序?
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论