[dbo].[XMLFragment]

(local) > itpam > Tables > dbo.XMLFragment

Properties
Columns
Indexes
SQL Script
Uses

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

Columns

Name	Data Type	Max Length (Bytes)	Identity	Default
DocXML	text	max
OID	int	4
ID	int	4	1 - 1
compressedDoc	tinyint	1		((0))

Indexes

	Name	Columns	Unique
	PK_XMLFragment_ID	ID

SQL Script

CREATE TABLE [dbo].[XMLFragment]
(
[DocXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OID] [int] NULL,
[ID] [int] NOT NULL IDENTITY(1, 1),
[compressedDoc] [tinyint] NOT NULL CONSTRAINT [DF__XMLFragme__compr__36B12243] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[XMLFragment] ADD CONSTRAINT [PK_XMLFragment_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO

Uses