[usmuser].[usm_mr_itemp

[usmuser].[usm_mr_itemp_001003]

(local) > mdb > Tables > usmuser.usm_mr_itemp_001003

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	4:09:12 AM Friday, July 24, 2009
Last Modified	4:09:12 AM Friday, July 24, 2009

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

SQL Script

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

Uses

usmuser