Tables [dbo].[usm_metric_resultxxxxx]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:08:09 AM Wednesday, March 07, 2007
Last Modified1:17:01 PM Tuesday, March 30, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
sm_start_timedatetime8
Yes
sm_end_timedatetime8
Yes
sm_resultfloat8
Yes
sm_result_statusint4
Yes
sm_excludeint4
Yes
grouped_byvarchar(20)20
Yes
group_by_typeint4
Yes
Foreign Keys $usm_m_r0000272500000000: [dbo].[usm_metric_instance].metric_instance_idmetric_instance_idint4
Yes
maximumfloat8
Yes
minimumfloat8
Yes
no_of_samplesint4
Yes
reduction_levelint4
Yes
Foreign Keys Foreign Keys
NameColumns
$usm_m_r0000272500000000metric_instance_id->[dbo].[usm_metric_instance].[metric_instance_id]
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_metric_resultxxxxx]
(
[sm_start_time] [datetime] NULL,
[sm_end_time] [datetime] NULL,
[sm_result] [float] NULL,
[sm_result_status] [int] NULL,
[sm_exclude] [int] NULL,
[grouped_by] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_by_type] [int] NULL,
[metric_instance_id] [int] NULL,
[maximum] [float] NULL,
[minimum] [float] NULL,
[no_of_samples] [int] NULL,
[reduction_level] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_metric_resultxxxxx] ADD CONSTRAINT [$usm_m_r0000272500000000] FOREIGN KEY ([metric_instance_id]) REFERENCES [dbo].[usm_metric_instance] ([metric_instance_id])
GO
GRANT SELECT ON  [dbo].[usm_metric_resultxxxxx] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_metric_resultxxxxx] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_metric_resultxxxxx] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_metric_resultxxxxx] TO [usmgroup]
GO
Uses