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, 1330🔥, 0💬
Popular Posts:
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
How to expand IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has ...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to convert a date and time to a standard format? Date and time can be displayed in a number of s...