Xml Shredding

  
sql server version

1
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) 
	Feb 20 2014 19:20:46 
	Copyright (c) Microsoft Corporation
	Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)



  
TableName
SchemaName
TextImageFileGroup
ColName
DataType
DataTypeMaxLength
DataTypePrecision
DataTypeScale
IsIdentityColumn
IdentitySeedValue
IdentityIncrementValue
IsColumnNullable
PrimaryKey

1
__MigrationHistory
dbo
PRIMARY
MigrationId
nvarchar
300
0
0
0
NULL
NULL
0
1

2
__MigrationHistory
dbo
PRIMARY
ContextKey
nvarchar
600
0
0
0
NULL
NULL
0
1

3
__MigrationHistory
dbo
PRIMARY
Model
varbinary
-1
0
0
0
NULL
NULL
0
0

4
__MigrationHistory
dbo
PRIMARY
ProductVersion
nvarchar
64
0
0
0
NULL
NULL
0
0

5
CoatingCost
dbo
NULL
CoatingCostId
int
4
10
0
1
1
1
0
1

6
CoatingCost
dbo
NULL
CoatingId
int
4
10
0
0
1
1
0
0

7
CoatingCost
dbo
NULL
LabId
int
4
10
0
0
1
1
1
0

8
CoatingCost
dbo
NULL
Cost
money
8
19
4
0
1
1
0
0

9
CoatingCost
dbo
NULL
Price
money
8
19
4
0
1
1
0
0

10
ContactLens
dbo
NULL
ProductId
int
4
10
0
0
NULL
NULL
0
0