如何使用t-sql获取存储过程中使用的表及其对应的列名？有人可以帮我这个吗？ [英] How to fetch tables and their corresponding column names used in stored procedures using t-sql? Can anyone please help me with this?

问题描述

我只想获取使用t-sql作为存储过程的一部分写入的表及其对应的列？我怎样才能得到相同的清单？谁能帮我？谢谢

解决方案

看看这里：列出SQL Server数据库中每个表的列和属性 [ ^ ]

请不要害怕使用 Google [ ^ ]！

大家好，我试着努力解决我的问题。

  SELECT   distinct  sp.name  as  StoredProc，tbl.name  AS  [表]，col.name  AS  [列] 
  FROM  sysobjects sp 
  INNER   JOIN  sysdepends sd  ON  sp.id = sd.id 
  INNER   JOIN  sysobjects tbl  ON  tbl.id = sd.depid 
  INNER   JOIN  syscolumns col  ON  col .colid = sd.depnumber  AND  col.id = sd.depid 
  WHERE  sp.name  IN （ SELECT  name  FROM  sysobjects  WHERE  id  IN （ SELECT  id 来自 syscomments  WHERE   text   LIKE  ' ％passParamToGetYourSPs _％'））
   -    group BY sp.name  
   -    AND sp.name ='Search_SP_Name' 
  ORDER   BY  sp.name，tbl.name，col.name 

感谢您的所有努力。 ：）

I just want to get the tables and their corresponding columns which are written as a part of stored procedure using t-sql? How can I get a list of the same? Can anyone help me? Thanks

解决方案

Have a look here: List columns and attributes for every table in a SQL Server database[^]
Please, do not afraid to use Google[^]!

Hello guys, I tried following effort to get my query resolved.

SELECT distinct sp.name as StoredProc, tbl.name AS [Table], col.name AS [Column]
FROM sysobjects sp
INNER JOIN sysdepends sd ON sp.id = sd.id
INNER JOIN sysobjects tbl ON tbl.id = sd.depid
INNER JOIN syscolumns col ON col.colid = sd.depnumber AND col.id = sd.depid
WHERE sp.name IN ( SELECT name FROM sysobjects WHERE id IN(SELECT id from syscomments WHERE text LIKE '%passParamToGetYourSPs_%'))
--group BY sp.name
--AND sp.name = 'Search_SP_Name'
ORDER BY sp.name, tbl.name, col.name

Thanks for all your efforts. :)

这篇关于如何使用t-sql获取存储过程中使用的表及其对应的列名？有人可以帮我这个吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！