Find an Object Name and ID

To identify the ID and name of an object, use object_id() and object_name().

The syntax is:
select object_id("titles")
----------
  208003772

Object names and IDs are stored in the sysobjects system table.