Rediger

Del via


sys.pdw_health_component_properties (Transact-SQL)

Applies to: Analytics Platform System (PDW)

Stores properties that describe a device. Some properties show device status and some properties describe the device itself.

Column Name Data Type Description Range
property_id int Unique identifier of the property of a component.

property_id and component_id form the key for this view.
NOT NULL
component_id int The ID of the component. See sys.pdw_health_components (Transact-SQL).

property_id and component_id form the key for this view.
NOT NULL
property_name nvarchar(255) Name of the property. NOT NULL
physical_name nvarchar(32) Property name as defined by the manufacturer. NOT NULL
is_key bit Determines whether the device instance is unique or not unique. NOT NULL

0 - Device instance is unique.

1 - Device instance is not unique.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views