[dbo].[CollabResponses]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	8
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:47 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:47 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity
responseID	int	4	1 - 1
responseName	nvarchar(128)	256
responseText	ntext	max
responseTitle	nvarchar(128)	256
responseType	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

responseID

int

1 - 1

responseName

nvarchar(128)

256

responseText

ntext

max

responseTitle

nvarchar(128)

256

responseType

int

	Name	Columns	Unique
	pk_responses	responseID

Name

Columns

Unique

pk_responses

responseID

SQL Script

CREATE TABLE [dbo].[CollabResponses]
(
[responseID] [int] NOT NULL IDENTITY(1, 1),
[responseName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[responseText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[responseTitle] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[responseType] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[CollabResponses] ADD CONSTRAINT [pk_responses] PRIMARY KEY CLUSTERED ([responseID]) ON [PRIMARY]
GO