sys.fn_listextendedproperty

Description

Returns extended property values of database objects. Valid inputs are default, NULL, or a Is the user or user-defined type.

Syntax

fn_listextendedproperty (
{ default | 'property_name' | NULL }
, { default | 'level0_object_type' | NULL }
, { default | 'level0_object_name' | NULL }
, { default | 'level1_object_type' | NULL }
, { default | 'level1_object_name' | NULL }
, { default | 'level2_object_type' | NULL }
, { default | 'level2_object_name' | NULL }
)

Arguments

Returns extended property values of database objects.

{ default | ’

property_name

Is the name of the property.

property_name. Valid inputs are default, NULL, or a

property name.

{ default | ’

level0_object_type

Is the user or user-defined type.

level0_object_type

, with a default of NULL.

Valid inputs are:

EVENT NOTIFICATION

MESSAGE TYPE

PARTITION FUNCTION

PARTITION SCHEME

REMOTE SERVICE BINDING