SQL Server Performance Forum – Threads Archive

question related to system tables

I need the query for this Join two/one system tables to find the name of the objects by inputting a search string "string" as the where clause….. Please help

It’s exactly the same as querying user tables, just different table names – at least as long as you’re not in SQL 2005. Read the details in BOL to see which are the foreign key columns.

Check out the INFORMATION_SCHEMA views in BOL. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

eg Select table_name from INFORMATION_SCHEMA.tables where table_name like ‘%string%’ Madhivanan Failing to plan is Planning to fail

"to find the name of the objects"
by ‘objects’ do you mean table, view, stored prodedure, function etc ?
select * from sysobjects where name like ‘%string%
——
> KH <

Hi, or you may find it using ‘SQLDBSEARCH’ a free ware tool from<a target="_blank" href=http://www.sqldbtools.com>http://www.sqldbtools.com</a> . <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

thanx to everyone. I am new to SQL and job and thats y i was facing problem. Thanx a lot

Thanks for the link, Hemantgiri. Another resource I wasn’t aware of. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

Indeed… that is a good open source one. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>