[dbo].[JMS_SUBSCRIPTIONS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:42:02 AM Friday, March 26, 2010
Last Modified	11:42:02 AM Friday, March 26, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:42:02 AM Friday, March 26, 2010

Last Modified

11:42:02 AM Friday, March 26, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__JMS_SUBSCRIPTION__5FB337D6: CLIENTID\SUBNAME$	CLIENTID	varchar(128)	128
$Cluster Primary Key PK__JMS_SUBSCRIPTION__5FB337D6: CLIENTID\SUBNAME$	SUBNAME	varchar(128)	128
	TOPIC	varchar(255)	255
	SELECTOR	varchar(255)	255

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__JMS_SUBSCRIPTION__5FB337D6: CLIENTID\SUBNAME$

CLIENTID

varchar(128)

128

$Cluster Primary Key PK__JMS_SUBSCRIPTION__5FB337D6: CLIENTID\SUBNAME$

SUBNAME

varchar(128)

128

TOPIC

varchar(255)

255

SELECTOR

varchar(255)

255

	Name	Columns	Unique
$Cluster Primary Key PK__JMS_SUBSCRIPTION__5FB337D6: CLIENTID\SUBNAME$	PK__JMS_SUBSCRIPTION__5FB337D6	CLIENTID, SUBNAME

Name

Columns

Unique

$Cluster Primary Key PK__JMS_SUBSCRIPTION__5FB337D6: CLIENTID\SUBNAME$

PK__JMS_SUBSCRIPTION__5FB337D6

CLIENTID, SUBNAME

SQL Script

CREATE TABLE [dbo].[JMS_SUBSCRIPTIONS]
(
[CLIENTID] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SUBNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TOPIC] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SELECTOR] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JMS_SUBSCRIPTIONS] ADD CONSTRAINT [PK__JMS_SUBSCRIPTION__5FB337D6] PRIMARY KEY CLUSTERED ([CLIENTID], [SUBNAME]) ON [PRIMARY]
GO