[usmuser].[usm_mr_itemp

[usmuser].[usm_mr_itemp_001007]

(local) > mdb > Tables > usmuser.usm_mr_itemp_001007

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	34
Created	5:54:14 PM Thursday, January 06, 2011
Last Modified	5:54:15 PM Thursday, January 06, 2011

Columns

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

Indexes

Name	Columns
usm_mr_itemp_001007_idx1	bulk_id

SQL Script

CREATE TABLE [usmuser].[usm_mr_itemp_001007]
(
[bulk_id] [int] NULL,
[account_label_lookup] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[value] [float] NULL,
[time_stamp] [datetime] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [usm_mr_itemp_001007_idx1] ON [usmuser].[usm_mr_itemp_001007] ([bulk_id]) ON [PRIMARY]
GO

Uses

usmuser