[usmuser].[usm_mr_itemp

[usmuser].[usm_mr_itemp_001013]

(local) > mdb > Tables > usmuser.usm_mr_itemp_001013

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	4
Created	3:29:44 PM Thursday, May 19, 2011
Last Modified	3:29:44 PM Thursday, May 19, 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_001013_idx1	bulk_id

SQL Script

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

Uses

usmuser