[usmuser].[usm_mr_itemp

[usmuser].[usm_mr_itemp_001020]

(local) > mdb > Tables > usmuser.usm_mr_itemp_001020

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	4
Created	5:47:27 PM Tuesday, December 15, 2009
Last Modified	5:47:27 PM Tuesday, December 15, 2009

Columns

Name	Data Type	Max Length (Bytes)
bulk_id	int	4
value	float	8
time_stamp	datetime	8
account_label_lookup	varchar(128)	128

Indexes

Name	Columns
usm_mr_itemp_001020_idx1	bulk_id

SQL Script

CREATE TABLE [usmuser].[usm_mr_itemp_001020]
(
[bulk_id] [int] NULL,
[value] [float] NULL,
[time_stamp] [datetime] NULL,
[account_label_lookup] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_itemp_001020_idx1] ON [usmuser].[usm_mr_itemp_001020] ([bulk_id]) ON [PRIMARY]
GO

Uses

usmuser