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
2019-07-09, 560👍, 0💬
Related Topics:
