question related to system tables | SQL Server Performance Forums

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
Heute schon gebloggt?
Ich unterstuetze PASS Deutschland e.V.
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,<br />or you may find it using ‘SQLDBSEARCH’ a free ware tool from<a target="_blank" href=></a> .<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
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=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Heute schon gebloggt?<a target="_blank" href=></a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=></a>)
Indeed… that is a good open source one. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.