What Is OBJECT_ID()

Q

What Is OBJECT_ID() function in SQL Server?

✍: FYIcenter.com

A

OBJECT_ID() is a system function in a SQL Server Database that returns the object_id value from the sys.objects table for a given object name.

The following query will return the same result:

SELECT OBJECT_ID('ADDRESS') AS object_id
211197

SELECT object_id FROM sys.objects WHERE name = 'ADDRESS'
211197

Using OBJECT_ID() function will help to avoid using an extra table join with the sys.objects. For example, the following query will list all columns in the table ADDRESS:

SELECT * FROM sys.columns where object_id = OBJECT_ID('ADDRESS') 

 

What Is a SQL Server Partition

What Is sys.objects

SQL Server System Views and Functions

⇑⇑ SQL Server Storage Tutorials

2019-07-09, 220👍, 0💬