×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Chicago

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

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论