Tables [dbo].[StartProcessServiceOperation]
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
Parameter4varchar(255)255
Yes
('')
Parameter1varchar(255)255
Yes
('')
IsLoadOSProfiletinyint1
Yes
StdErrFileNamevarchar(255)255
Yes
('')
IsTruncateForStdErrtinyint1
Yes
ProgramNamevarchar(255)255
Yes
('')
StdOutFileNamevarchar(255)255
Yes
('')
Parameter2varchar(255)255
Yes
('')
ScriptTypevarchar(255)255
Yes
('')
Parameter3varchar(255)255
Yes
('')
IsPostToGlobalLogtinyint1
Yes
Cluster Primary Key PK__StartProcessServ__778AC167: RefIDRefIDvarchar(255)255
No
('')
Parameter5varchar(255)255
Yes
('')
UserIDvarchar(255)255
Yes
('')
WorkingDirvarchar(255)255
Yes
('')
InLineScriptvarchar(255)255
Yes
('')
IsTruncateForStdOuttinyint1
Yes
Profilevarchar(255)255
Yes
('')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__StartProcessServ__778AC167: RefIDPK__StartProcessServ__778AC167RefID
Yes
SQL Script
CREATE TABLE [dbo].[StartProcessServiceOperation]
(
[Parameter4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Param__6A30C649] DEFAULT (''),
[Parameter1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Param__6B24EA82] DEFAULT (''),
[IsLoadOSProfile] [tinyint] NULL,
[StdErrFileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__StdEr__6C190EBB] DEFAULT (''),
[IsTruncateForStdErr] [tinyint] NULL,
[ProgramName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Progr__6D0D32F4] DEFAULT (''),
[StdOutFileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__StdOu__6E01572D] DEFAULT (''),
[Parameter2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Param__6EF57B66] DEFAULT (''),
[ScriptType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Scrip__6FE99F9F] DEFAULT (''),
[Parameter3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Param__70DDC3D8] DEFAULT (''),
[IsPostToGlobalLog] [tinyint] NULL,
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__StartProc__RefID__71D1E811] DEFAULT (''),
[Parameter5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Param__72C60C4A] DEFAULT (''),
[UserID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__UserI__73BA3083] DEFAULT (''),
[WorkingDir] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Worki__74AE54BC] DEFAULT (''),
[InLineScript] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__InLin__75A278F5] DEFAULT (''),
[IsTruncateForStdOut] [tinyint] NULL,
[Profile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__StartProc__Profi__76969D2E] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StartProcessServiceOperation] ADD CONSTRAINT [PK__StartProcessServ__778AC167] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO
Uses