Tables [dbo].[SOS_SurveyMasterQuestion]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:51 AM Thursday, March 21, 2019
Last Modified1:00:51 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SOS_SURVEYMASTERQUESTION: C_SURVEYMASTERQUESTIONIDC_SURVEYMASTERQUESTIONIDint4
False
1000 - 1
CREATEUSERchar(12)12
True
CREATEDATEdatetime8
True
MODIFYUSERchar(12)12
True
MODIFYDATEdatetime8
True
Q1varchar(250)250
True
Q2varchar(250)250
True
Q3varchar(250)250
True
Q4varchar(250)250
True
Q5varchar(250)250
True
Q6varchar(250)250
True
Q7varchar(250)250
True
Q8varchar(250)250
True
Q9varchar(250)250
True
Q10varchar(250)250
True
Q11varchar(250)250
True
Q12varchar(250)250
True
Q13varchar(250)250
True
Q14varchar(250)250
True
Q15varchar(250)250
True
Q16varchar(250)250
True
Q17varchar(250)250
True
Q18varchar(250)250
True
Q19varchar(250)250
True
Q20varchar(250)250
True
SURVEYNAMEvarchar(32)32
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SOS_SURVEYMASTERQUESTION: C_SURVEYMASTERQUESTIONIDPK_SOS_SURVEYMASTERQUESTIONC_SURVEYMASTERQUESTIONID
True
80
CREATE TABLE [dbo].[SOS_SurveyMasterQuestion]
(
[C_SURVEYMASTERQUESTIONID] [int] NOT NULL IDENTITY(1000, 1),
[CREATEUSER] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATEDATE] [datetime] NULL,
[MODIFYUSER] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MODIFYDATE] [datetime] NULL,
[Q1] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q2] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q3] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q4] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q5] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q6] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q7] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q8] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q9] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q10] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q11] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q12] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q13] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q14] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q15] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q16] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q17] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q18] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q19] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q20] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SURVEYNAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOS_SurveyMasterQuestion] ADD CONSTRAINT [PK_SOS_SURVEYMASTERQUESTION] PRIMARY KEY CLUSTERED  ([C_SURVEYMASTERQUESTIONID]) ON [PRIMARY]
GO