Database - What Is OBJECT

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

⇐ What Is sys.objects

⇑ SQL Server System Views and Functions

⇑⇑ SQL Server Storage Tutorials

2019-07-09, 351👍, 0💬

What Is sys.objects
What Is sys.objects view in SQL Server? sys.objects is a system view in a SQL Server Database that contains information about each data object like a table or an index used by the database. Each record in the sys.objects table represents a single data object with the following key fields: name - sys... 2019-07-09, 317👍, 0💬

What Is sys.partitions?
What Is sys.partitions view in SQL Server? sys.partitions is a system view in a SQL Server Database that contains information about each data partition used by a data object in the database. Each record in the sys.partitions table represents a single data partition with the following key fields: par... 2019-07-09, 317👍, 0💬

List All Files in a Filegroup
How to List All physical Files in a logical Filegroup? In a large SQL Server Database, you may have multiple logical Filegroups. And a Filegroup may have multiple physical Files. To list all physical Files in a logical Filegroup, you need to join two system tables, sys.filegroups and sys.database_fi... 2019-07-09, 291👍, 0💬

What Is a SQL Server Partition
What Is a SQL Server Partition? A SQL Server Partition represents a logical data storage space area that is used to store data for a table or other data objects. By default all records in a table are stored in a single Partition. You may configure a table as Partitioned with use multiple partitions,... 2019-07-09, 269👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.