Chapter 11: Views: Limiting Access to Data

Finding an object name and ID

The system functions object_id() and object_name() identify the ID and name of a view. For example:

select object_id("titleview")

----------
 480004741

Object names and IDs are stored in the sysobjects table.