Tables [usmuser].[usm_mr_itemp_001016]
Properties
PropertyValue
HeapYes
Row Count3000
Created5:43:56 AM Wednesday, July 29, 2009
Last Modified5:43:56 AM Wednesday, July 29, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes usm_mr_itemp_001016_idx1: bulk_idbulk_idint4
Yes
time_stampint4
Yes
valuefloat8
Yes
target_host_idint4
Yes
Indexes Indexes
NameColumns
usm_mr_itemp_001016_idx1bulk_id
SQL Script
CREATE TABLE [usmuser].[usm_mr_itemp_001016]
(
[bulk_id] [int] NULL,
[time_stamp] [int] NULL,
[value] [float] NULL,
[target_host_id] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_itemp_001016_idx1] ON [usmuser].[usm_mr_itemp_001016] ([bulk_id]) ON [PRIMARY]
GO
Uses