Get the Name - Using the OBJECT_NAME Function

Object_Name is one of the functions I use over and over as I work with system views, it's easy to use way to get the name of an object from an object_id, and it's far more concise than a join to sys.sysobjects. We'll show you both techniques in this lesson just in case you need more than just the object name on occcasion.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Gilles Despaties on 12/3/2010

Thanks ! Another trick under "my" hood

37F4DA828D on 12/3/2010

love Andy's stuff - thanks!

Sainey M. Drammeh on 12/3/2010

Thanks.

Jamshid Nouri on 12/3/2010

excellent, short and powerful

Mark Hathaway on 12/3/2010

I was suprised you didn't mention the information_schema.columns view.

E72B0A9423 on 12/3/2010

seeing a different way of using a function may inspire me to use funtions in different ways in the future.

Rod on 12/3/2010

I never knew about this, thank you!

Ron Saxer on 12/3/2010

You have an excelent voice and pace for demos

Nilesh on 12/3/2010

nice

Gil on 12/3/2010

For databases with lots of schemas, sometimes the name isn't enough. If there is an easy way to get the schema-qualified object name, that would have been useful to note. Especially if there's something easier than this kind of thing: quotename(object_schema_name(object_id),'[') + '.' + quotename(object_name(object_id),'[')

Charlie Bruno on 12/3/2010

Excellent and informative as usual. Thanks.

Margie on 12/3/2010

Oh my gosh this was useful! I have working on this project where I needed just this answer of Object name and not the obeject id. ! Thanks Andy!

kalapala baburao on 12/4/2010

good

harish on 12/4/2010

good

phuc bui van on 12/5/2010

good!

Terrance on 12/5/2010

Very good information.

Olu on 12/7/2010

Very good and really useful, but the volume was too low

Maurice Ivory on 6/20/2011

I think I have to give this a try before I can say how usefull it would be.

MohanD on 12/10/2011

Learned a New function... Thanks,