Tables [dbo].[PromptUserServiceOperation]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:43:57 AM Friday, March 26, 2010
Last Modified11:43:57 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Usersvarchar(255)255
Yes
Groupsvarchar(255)255
Yes
TimeoutMinutesint4
Yes
Descriptionvarchar(255)255
Yes
('')
NoTimeouttinyint1
Yes
TimeoutHoursint4
Yes
UserInputFormvarchar(255)255
Yes
('')
Titlevarchar(255)255
Yes
('')
Cluster Primary Key PK__PromptUserServic__1BC821DD: RefIDRefIDvarchar(255)255
No
('')
TimeoutDaysint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__PromptUserServic__1BC821DD: RefIDPK__PromptUserServic__1BC821DDRefID
Yes
SQL Script
CREATE TABLE [dbo].[PromptUserServiceOperation]
(
[Users] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Groups] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TimeoutMinutes] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__PromptUse__Descr__17F790F9] DEFAULT (''),
[NoTimeout] [tinyint] NULL,
[TimeoutHours] [int] NULL,
[UserInputForm] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__PromptUse__UserI__18EBB532] DEFAULT (''),
[Title] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__PromptUse__Title__19DFD96B] DEFAULT (''),
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__PromptUse__RefID__1AD3FDA4] DEFAULT (''),
[TimeoutDays] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PromptUserServiceOperation] ADD CONSTRAINT [PK__PromptUserServic__1BC821DD] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO
Uses