[usmuser].[usm_mr_itemp

[usmuser].[usm_mr_itemp_001017]

(local) > mdb > Tables > usmuser.usm_mr_itemp_001017

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Heap
Row Count	3000
Created	5:44:31 AM Wednesday, July 29, 2009
Last Modified	5:44:31 AM Wednesday, July 29, 2009

Columns

Name	Data Type	Max Length (Bytes)
bulk_id	int	4
time_stamp	int	4
value	float	8
target_host_id	int	4

Indexes

Name	Columns
usm_mr_itemp_001017_idx1	bulk_id

SQL Script

CREATE TABLE [usmuser].[usm_mr_itemp_001017]
(
[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_001017_idx1] ON [usmuser].[usm_mr_itemp_001017] ([bulk_id]) ON [PRIMARY]
GO

Uses

usmuser