[dbo].[report_session]

(local) > ODSTrack > Tables > dbo.report_session

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	2
Created	4:53:08 PM Sunday, February 07, 2010
Last Modified	4:53:08 PM Sunday, February 07, 2010

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_report_session: username\session_id$	username	nvarchar(255)	510
$Cluster Primary Key pk_report_session: username\session_id$	session_id	nvarchar(50)	100
	created	datetime	8
	xml	ntext	max

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_report_session: username\session_id$	pk_report_session	username, session_id

SQL Script

CREATE TABLE [dbo].[report_session]
(
[username] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[session_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[created] [datetime] NOT NULL,
[xml] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[report_session] ADD CONSTRAINT [pk_report_session] PRIMARY KEY CLUSTERED ([username], [session_id]) ON [PRIMARY]
GO

Uses