List Info

Thread: Search for a table name in SQL Database
Search for a table name in SQL Database
country flaguser name
United States		 2007-10-19 10:05:39 

  


  

    




  



    

            
How can I search within a database with many tables and stored procedures and even some CLR procedures a table name or column name? I want to find out where the tables or columns being used and for what purpose?


Thanks

Ying



[Non-text portions of this message have been removed]






    
  

    
    __._,_.___
    
     
    
    
  
.


    


__,_._,___



  

  
  
   
     
    

  

    Re:  Search for a table name in SQL
Database
  


  

     country flaguser name
United States		
     2007-10-19 10:34:54
  


  

    

  


  

    




  



    

            
Not sure about the CLR (still stuck in 2000 land)

but this will get you at least the native goodies



sp_depends 'ObjectName'



On 10/19/07, Ying Jin < yingjin_us%40yahoo.com">yingjin_usyahoo.com> wrote:

&gt;

> How can I search within a database with many tables and stored procedures

> and even some CLR procedures a table name or column name? I want to find out

> where the tables or columns being used and for what purpose?


> Thanks

&gt; Ying

>;

>

> [Non-text portions of this message have been removed]


>

>;

>

>

> Yahoo! Groups Links

&gt;

>


>

>;



-- 

Dean Fiala

Very Practical Software, Inc

Now with Blogging...

http://www.vpsw.com/blogbaby


Microsoft MVP



[Non-text portions of this message have been removed]






    
  

    
    __._,_.___
    
     
    
    
  
.


    


__,_._,___



  

  
  
   
     
    






 [1-2]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )