SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,165 questions
List of the tables from Stored procedure
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 35%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
srk
41
Reputation points
Hi there,
I was trying to find list of the tables used in stored procedure as we did use the tables in INSERT, UPDATE, IN JOINS , TRUNCATE as well. I would like to get the list of the tables part of above operations please.
Please let me know.
2 answers
Sort by: Most helpful
-
Olaf Helper 45,371 Reputation points2023-08-30T11:55:25.68+00:00 -
srk 41 Reputation points
2023-08-30T14:04:47.6766667+00:00 Its not helpful.
Create procedure xyz as insert into table1 select * from table2 update table3 set name =fullname from table1 tb1 inner join table3 tb3 on tb1.id = tb3.idI am expecting like below in the output result. I know it is not straight forward but will be great if anyone got any idea on this.
Just trying to get the tables list that are part of INSERT, Update, Select list
Many thanks
Sign in to comment -
-
Erland Sommarskog 113.7K Reputation points MVP2023-08-30T21:56:19.1733333+00:00 There is no straightforward way to do this - you would need to parse the code.
But for some ideas of what is available in terms of partial solution, see the short story Where Is that Table Used? on my web site.