Table or Query information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know of a query that will tell me the type of each query
within a database, AND what tables/fileds it updates/makes.
OR
query each table within a database and have it tell me all of the queries
that can update/make it.

Thank you,
Jim
 
This does not give me all of the information I need. AND it is not as easy
as as query against an object such as MSysObjects.

Any other ideas?
 
I found a query in prior posts that reads:

SELECT MSysObjects.Name, MSysQueries.Name1
FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id =
MSysQueries.ObjectId
WHERE MSysQueries.Name1 = [Enter TABLE Name]

Can it be modified in any way to show all update or make table queries that
write to the table [Enter TABLE Name]
 
I get the following errors in the Analyzer...

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MSysObjects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MSysQueries'.
 
Back
Top