[dbo].[report_settings]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

4:53:08 PM Sunday, February 07, 2010

Last Modified

4:53:08 PM Sunday, February 07, 2010

Name	Data Type	Max Length (Bytes)	Identity
report_settings_id	int	4	1 - 1
report_type	nvarchar(50)	100
username	nvarchar(255)	510
name	nvarchar(255)	510
settings_xml	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

report_settings_id

int

1 - 1

report_type

nvarchar(50)

100

username

nvarchar(255)

510

name

nvarchar(255)

510

settings_xml

ntext

max

	Name	Columns	Unique
	PK_report_settings	report_settings_id

Name

Columns

Unique

PK_report_settings

report_settings_id

SQL Script

CREATE TABLE [dbo].[report_settings]
(
[report_settings_id] [int] NOT NULL IDENTITY(1, 1),
[report_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[username] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[settings_xml] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[report_settings] ADD CONSTRAINT [PK_report_settings] PRIMARY KEY CLUSTERED ([report_settings_id]) ON [PRIMARY]
GO