Tables [dbo].[SOAPClientCall]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count332
Created11:43:57 AM Friday, March 26, 2010
Last Modified11:43:57 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
ResponseFilevarchar(255)255
Yes
SavedCallFilevarchar(255)255
Yes
Cluster Primary Key PK__SOAPClientCall__160F4887: RefIDRefIDvarchar(255)255
No
('')
MethodNamevarchar(255)255
Yes
ServiceURLvarchar(255)255
Yes
AuthorisedUservarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__SOAPClientCall__160F4887: RefIDPK__SOAPClientCall__160F4887RefID
Yes
SQL Script
CREATE TABLE [dbo].[SOAPClientCall]
(
[ResponseFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SavedCallFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__SOAPClien__RefID__151B244E] DEFAULT (''),
[MethodName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AuthorisedUser] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOAPClientCall] ADD CONSTRAINT [PK__SOAPClientCall__160F4887] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO
Uses