Syntax of OBJECT_NAME Function :
OBJECT_NAME ( object_id )
object_id is an identification number of object. It is of type integer.
Return type of OBJECT_NAME function is a nchar.
Examples of OBJECT_NAME Function :
Example 1 : Use of OBJECT_NAME function in select clause
SELECT OBJECT_NAME(917578307)
Output
Customers
Above example returns object name of specified object id of northwind database.