partition_object_id

Displays the object ID for a specified partition ID and database ID.

Syntax

partition_object_id(partition_id [, database_id ] )

Parameters

partition_id – is the ID of the partition whose object ID is to be retrieved.
database_id – is the database ID of the partition.

Examples

Example 1 – Displays the object ID for partition ID 2:
```
select partition_object_id(2)
```
Example 2 – Displays the object ID for partition ID 14 and database ID 7:
```
select partition_object_id(14,7)
```
Example 3 – Returns a NULL value for the database ID because a NULL value is passed to the function:
```
select partition_object_id( 1424005073, NULL)
```
```
 -----------
NULL
(1 row affected)
```

Usage

partition_object_id uses the current database ID if you do not include a database ID.
partition_object_id returns NULL if you:
- Use a NULL value for the partition_id.
- Include a NULL value for database_id.
- Provide an invalid or non-existent partition_id or database_id.

Parent topic: Transact-SQL Functions

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com