[usmuser].[USM_SUBSCRIPTION_KEY

[usmuser].[USM_SUBSCRIPTION_KEY_HOST]

(local) > mdb > Tables > usmuser.USM_SUBSCRIPTION_KEY_HOST

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	12:00:15 PM Monday, January 25, 2010
Last Modified	12:00:16 PM Monday, January 25, 2010

Columns

Name	Data Type	Max Length (Bytes)
text_1	varchar(50)	50
host_id	varchar(50)	50
host_name	varchar(50)	50

Indexes

Name	Columns
USM_SUBSCRIPTION_KEY_HOST_idx	text_1

SQL Script

CREATE TABLE [usmuser].[USM_SUBSCRIPTION_KEY_HOST]
(
[text_1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [USM_SUBSCRIPTION_KEY_HOST_idx] ON [usmuser].[USM_SUBSCRIPTION_KEY_HOST] ([text_1]) ON [PRIMARY]
GO

Uses

usmuser