partition_object_id

Description

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

Syntax

partition_object_id(partition_id [, database_id ] )

Parameters

Examples

Example 1

Displays the object ID for the partition whose partition ID is 2:

select partition_object_id(2)

Example 2

Displays the object ID for the partition whose partition ID is 14 and whose database ID is 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.

• partition_object_id returns a NULL value if you include a NULL value for database ID.

• partition_object_id returns NULL if you provide an invalid or non-existent partition_id or database_id.