[dbo].[JMS_MESSAGES]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:42:02 AM Friday, March 26, 2010
Last Modified	4:49:42 PM Tuesday, April 13, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

4:49:42 PM Tuesday, April 13, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__JMS_MESSAGES__619B8048: MESSAGEID\DESTINATION$	MESSAGEID	int	4
$Cluster Primary Key PK__JMS_MESSAGES__619B8048: MESSAGEID\DESTINATION$	DESTINATION	varchar(150)	150
	TXID	int	4
	TXOP	char(1)	1
	MESSAGEBLOB	image	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__JMS_MESSAGES__619B8048: MESSAGEID\DESTINATION$

MESSAGEID

int

$Cluster Primary Key PK__JMS_MESSAGES__619B8048: MESSAGEID\DESTINATION$

DESTINATION

varchar(150)

150

TXID

int

TXOP

char(1)

MESSAGEBLOB

image

max

	Name	Columns	Unique
$Cluster Primary Key PK__JMS_MESSAGES__619B8048: MESSAGEID\DESTINATION$	PK__JMS_MESSAGES__619B8048	MESSAGEID, DESTINATION
	JMS_MESSAGES_DESTINATION	DESTINATION

Name

Columns

Unique

$Cluster Primary Key PK__JMS_MESSAGES__619B8048: MESSAGEID\DESTINATION$

PK__JMS_MESSAGES__619B8048

MESSAGEID, DESTINATION

JMS_MESSAGES_DESTINATION

DESTINATION

SQL Script

CREATE TABLE [dbo].[JMS_MESSAGES]
(
[MESSAGEID] [int] NOT NULL,
[DESTINATION] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TXID] [int] NULL,
[TXOP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MESSAGEBLOB] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JMS_MESSAGES] ADD CONSTRAINT [PK__JMS_MESSAGES__619B8048] PRIMARY KEY CLUSTERED ([MESSAGEID], [DESTINATION]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [JMS_MESSAGES_DESTINATION] ON [dbo].[JMS_MESSAGES] ([DESTINATION]) ON [PRIMARY]
GO