Tables [dbo].[FileTransferServiceOperation]
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
IsSecureFTPtinyint1
Yes
IsInlinetinyint1
Yes
LocalFilevarchar(255)255
Yes
IsSiteCommandtinyint1
Yes
RemoteHostvarchar(255)255
Yes
IsBinaryTransfertinyint1
Yes
SiteParametersvarchar(255)255
Yes
Cluster Primary Key PK__FileTransferServ__7E37BEF6: RefIDRefIDvarchar(255)255
No
('')
RemoteUserIdvarchar(255)255
Yes
RemoteFilevarchar(255)255
Yes
InlineDatavarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__FileTransferServ__7E37BEF6: RefIDPK__FileTransferServ__7E37BEF6RefID
Yes
SQL Script
CREATE TABLE [dbo].[FileTransferServiceOperation]
(
[IsSecureFTP] [tinyint] NULL,
[IsInline] [tinyint] NULL,
[LocalFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsSiteCommand] [tinyint] NULL,
[RemoteHost] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsBinaryTransfer] [tinyint] NULL,
[SiteParameters] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__FileTrans__RefID__7D439ABD] DEFAULT (''),
[RemoteUserId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RemoteFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InlineData] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FileTransferServiceOperation] ADD CONSTRAINT [PK__FileTransferServ__7E37BEF6] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO
Uses