Collections:
What Is OBJECT_ID()
What Is OBJECT_ID() function in SQL Server?
✍: FYIcenter.com
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, 1829🔥, 0💬
Popular Posts:
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to find out my browser's identification information? To help you to see your browser identificat...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...