[dbo].[ItpamSoapAttachment]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:42:02 AM Friday, March 26, 2010
Last Modified	11:42:02 AM Friday, March 26, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:42:02 AM Friday, March 26, 2010

Last Modified

11:42:02 AM Friday, March 26, 2010

Name	Data Type	Max Length (Bytes)	Identity
name	varchar(50)	50
contentType	varchar(255)	255
contentID	varchar(255)	255
attachment	image	max
creationDate	datetime	8
attachmentID	int	4	1 - 1

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

name

varchar(50)

contentType

varchar(255)

255

contentID

varchar(255)

255

attachment

image

max

creationDate

datetime

attachmentID

int

1 - 1

	Name	Columns	Unique
	PK_ItpamSoapAttachment_attachmentID	attachmentID

Name

Columns

Unique

PK_ItpamSoapAttachment_attachmentID

attachmentID

SQL Script

CREATE TABLE [dbo].[ItpamSoapAttachment]
(
[name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contentType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contentID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[attachment] [image] NOT NULL,
[creationDate] [datetime] NULL,
[attachmentID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ItpamSoapAttachment] ADD CONSTRAINT [PK_ItpamSoapAttachment_attachmentID] PRIMARY KEY CLUSTERED ([attachmentID]) ON [PRIMARY]
GO