x002548's Blog - Friday, September 22, 2006 Entries

Posts: 83
Comments: 600
Trackbacks: 40

Friday, September 22, 2006

How do I find all the tables referenced by Stored Procedures or Functions

Like this

SELECT o.name, t.TABLE_NAME, c.text
FROM syscomments c
JOIN sysobjects o
ON c.id = o.id
JOIN INFORMATION_SCHEMA.Tables t
ON c.text LIKE '%'+t.TABLE_NAME+'%'

posted @ Friday, September 22, 2006 12:32 PM | Feedback (6)

Article Categories

DB2
West Orange Ridership Community

Archives

April, 2008 (1)
July, 2007 (1)
March, 2007 (2)
February, 2007 (4)
December, 2006 (1)
November, 2006 (2)
September, 2006 (4)
August, 2006 (2)
July, 2006 (2)
June, 2006 (3)
May, 2006 (2)
November, 2005 (1)
October, 2005 (1)
September, 2005 (1)
August, 2005 (2)
June, 2005 (8)
May, 2005 (6)
April, 2005 (5)
February, 2005 (4)
January, 2005 (5)
December, 2004 (2)
October, 2004 (2)
September, 2004 (2)
August, 2004 (1)
June, 2004 (6)
May, 2004 (2)
April, 2004 (2)
March, 2004 (2)
February, 2004 (3)
January, 2004 (2)
October, 2003 (1)
September, 2003 (1)

Post Categories

Code Generataion
DB2
Disconnected Ramblings
Oracle
SQL Gimmicks
SQL Server

Image Galleries

Directions
Lost Again?
Misc
Mountains
SQLSki Team

Misc

It's an Enigma Wrapped up in a riddle
Little Feat
Radio 'Rita
Ski Resort Cam List

SQL Server

Daily WTF (Doesn't mean World Tennis Federation)
dbForums Member List
SQL Express Team's BLOG
SQL Server 2000 Books Online
SQLTeam
SQLTeam Member List