Getting Table name

Question

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

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

Amit Khanna-455738 SSC Eights! Points: 865 More actions · Answer 1

SELECT * FROM SYS.TABLES WHERE NAME LIKE '%string%'

where string is word or table name to be serached

Thanks,

Amit Khanna

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 2

This should work:

SELECT t.TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES t

WHERE t.TABLE_NAME like '%some%'

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Abhijit More SSCertifiable Points: 6897 More actions · Answer 3

one more query..

select object_name(object_id), * from sys.objects where object_name(object_id) like 'sys%' and type = 'U'

Abhijit - http://abhijitmore.wordpress.com

hunt Right there with Babe Points: 780 More actions · Answer 4

Right there with Babe

Points: 780

August 22, 2008 at 5:33 am

thanku 🙂

thanks
sarat 🙂
Curious about SQL

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 5

There is clearly more than one way to skin a cat.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

hunt Right there with Babe Points: 780 More actions · Answer 6

Hi Abhijit

thanks for your reply...

i am getting error while executing it ..

ERROR: Invalid column name object_name and object_id

thanks
sarat 🙂
Curious about SQL

A_A_R_T SSC Eights! Points: 900 More actions · Answer 7

Is guess you're using MSSQL2000...

Try this one (it's a rewrite of Abhijit's code which was written for MSSQL2005):

select object_name(id), * from sysobjects where object_name(id) like 'sys%' and type = 'U'