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, 1340🔥, 0💬
Popular Posts:
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to use HTTP protocol to post an XML message to a server? You can follow this tutorial to post an...
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...