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, 1571🔥, 0💬
Popular Posts:
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to find out my browser's identification information? To help you to see your browser identificat...
How to generate date and time test values? Timestamp values are frequently needed in testing almost ...