InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:40:39 GMT20http://www.sqlservercentral.com/Forums/Topic695477-146-1.aspxYou could also use[code]sp_tables '%yourcriteria%'[/code]Wed, 15 Apr 2009 06:11:32 GMTWILLIAM MITCHELLhttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspxthnx for enlightening me. m still a novice...Mon, 13 Apr 2009 22:51:26 GMTHusain_Kachwalahttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspx[quote][b]ALZDBA (4/13/2009)[/b][hr][b]INFORMATION_SCHEMA views also work with pre sql2005 versions.[/b]To only select actual tables you need to add the where clause[code]Where TABLE_TYPE = 'BASE TABLE'[/code][/quote]thx. i didn't mean to imply that it wouldn't.Mon, 13 Apr 2009 13:31:16 GMThammerheadedhttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspx[b]INFORMATION_SCHEMA views also work with pre sql2005 versions.[/b]To only select actual tables you need to add the where clause[code]Where TABLE_TYPE = 'BASE TABLE'[/code]Mon, 13 Apr 2009 13:28:48 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspxif you're stuck in a pre 2005 world you would do:select * from sysobjects where type ='u'and name like '%your_table_name%' Mon, 13 Apr 2009 12:19:43 GMThammerheadedhttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspxYou can also try the following:use database_nameselect * from sys.tables where type ='u'and name like '%criteria%'Mon, 13 Apr 2009 06:03:42 GMTHusain_Kachwalahttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspxstart with:[code]Select ...from information_schema.tableswhere table_name like '%yourcryteria%'order by table_name[/code]Sun, 12 Apr 2009 11:07:51 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic695477-146-1.aspxHi,Can any body let me know the query to select all the tables in the database with a particular word on it.Thanks,SoofySun, 12 Apr 2009 10:17:00 GMTsoofy21