[usmuser].[usm_mr_itemp

[usmuser].[usm_mr_itemp_001004]

(local) > mdb > Tables > usmuser.usm_mr_itemp_001004

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	12
Created	10:03:33 AM Thursday, May 08, 2008
Last Modified	10:03:33 AM Thursday, May 08, 2008

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_001004_idx1	bulk_id

SQL Script

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

Uses

usmuser