object

Returns the object ID of the specified object.

Syntax

object_id(object_name)

object_name – is the name of a database object, such as a table, view, procedure, trigger, default, or rule. The name can be fully qualified (that is, it can include the database and owner name). Enclose the object_name in quotes.

Example 1 – Returns the object IDs from titles:

select object_id("titles")

----------- 
  208003772

Example 2 – Returns the object ID from sysobjects:

select object_id("master..sysobjects")

----------- 
          1

object_id, a system function, returns the object’s ID. Object IDs are stored in the id column of sysobjects.
Instead of consuming resources, object_id discards the descriptor for an object that is not already in the cache.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute object_id.