getting the object name using the object_id?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

Try the object_name() function... 😉

SELECT object_name(12345)

neotokyo SSCertifiable Points: 7239 More actions · Answer 2

so just as a test... i'll run a query against sysobjects with only

the name and id.

select name, id from master..sysobjects

i can then get the id to appear just as the object name using the object_name

function right?

so how would i put the object_name function into the select statement?

i think just a quick example would point me in the right direction.

sorry if this is sort of a fundamental question, but just to clear

things up a bit.

thanks

_________________________

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

Assuming I have a table named userobj that contains object IDs and a user ID:

create table userobj

(userid int,

objid int

)

select

userid, object_name(901578250)

from userobj

I select user ID from userobj and the object_name function gets the name of the object from sysobjects.

Greg

neotokyo SSCertifiable Points: 7239 More actions · Answer 4

thanks for the example! i see whats happening now.

i can see how it gets the name using each object id i

have in the parens, but i guess there's no way to do

it otherwise? like a table with 100 object id's. i

would need to write the query first with each id in

the parens ().

you answered my question though. thanks

_________________________