sql server: looking for table usage through out database -

What type of SQL code, such as procs, functions, views etc. are communicating with my table, called TABLE1 The sample code would be very useful to me through the given database.

thanks

  select so.name, so.xtype from sysobjects (Nolock) Internal login syscomments sc (nolock) at sc.id = so.id, where '% tablename%' such as sc.text ' 

This code will be used to reference all SQL The server will search the objects. You must do this to run this query for each database

If a stored procedure uses your table, it will appear in this query. This is also true about work, ideas and triggers.

xtype tells you the type of object

F = foreign key

Fn = function

PK = Primary Key

S = System Tables

U = User Tables

< Li> V = hidden tables