My colleagues asked me hundred times, how to find a particular columns, table name, stored procedure, views in the database.
Always forgot to remember one query. So for them only 🙂
Below query you can any table, stored procedure or views who ever have that expression as a column or object name.
SELECT * FROM SYSOBJECTS WHERE ID IN (SELECT ID FROM SYSCOMMENTS WHERE TEXT LIKE ‘%PRODUC%’)
The query produced all the object names. where ever it finds expression like ‘PRODUC‘
If you wanted to find any table name only then
SELECT * FROM SYSOBJECTS WHERE NAME LIKE ‘%TA%’ and xtype=‘u’
For stored procedure pass xtype=‘p’ and for views xtype=‘v’
Hope next time my friends will visit from my blog to get this query 😉