Select

Question

Post reply

Select

soofy21

SSC Enthusiast

Points: 144
More actions
April 12, 2009 at 10:17 am

#136569

Hi,
Can any body let me know the query to select all the tables in the database with a particular word on it.
Thanks,
Soofy

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 1

start with:

Select ...

from information_schema.tables

where table_name like '%yourcryteria%'

order by table_name

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Husain_Kachwala Ten Centuries Points: 1054 More actions · Answer 2

You can also try the following:

use database_name

select * from sys.tables where type ='u'

and name like '%criteria%'

hammerheaded Say Hey Kid Points: 706 More actions · Answer 3

if you're stuck in a pre 2005 world you would do:

select * from sysobjects where type ='u'

and name like '%your_table_name%'

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 4

INFORMATION_SCHEMA views also work with pre sql2005 versions.

To only select actual tables you need to add the where clause

Where TABLE_TYPE = 'BASE TABLE'