Chapter 8: Creating Databases and Tables

Finding an object name and ID

Use object_id() and object_name() to identify the ID and name of an object. For example:

select object_id("titles")

----------
  208003772

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