[dbo].[SessionEventJoin]

(local) > SupportBridge > Tables > dbo.SessionEventJoin

Properties
Columns
Indexes
SQL Script
Uses
Used By

Property	Value
Row Count	20679
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:47 PM Thursday, October 04, 2007

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key pk_SessionEventJoin: sessionID\eventID$ $Indexes ix_SessionEventJoin_eventID_sessionID: eventID\sessionID$	sessionID	int	4
$Cluster Primary Key pk_SessionEventJoin: sessionID\eventID$ $Indexes ix_SessionEventJoin_eventID_sessionID: eventID\sessionID$	eventID	decimal(28,0)	13

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_SessionEventJoin: sessionID\eventID$	pk_SessionEventJoin	sessionID, eventID
	ix_SessionEventJoin_eventID_sessionID	eventID, sessionID

SQL Script

CREATE TABLE [dbo].[SessionEventJoin]
(
[sessionID] [int] NOT NULL,
[eventID] [decimal] (28, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SessionEventJoin] ADD CONSTRAINT [pk_SessionEventJoin] PRIMARY KEY CLUSTERED ([sessionID], [eventID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_SessionEventJoin_eventID_sessionID] ON [dbo].[SessionEventJoin] ([eventID], [sessionID]) ON [PRIMARY]
GO

Uses

Used By