[dbo].[profile

[dbo].[profile_pki]

(local) > mdb > Tables > dbo.profile_pki

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	12:31:11 PM Sunday, December 05, 2010
Last Modified	12:31:11 PM Sunday, December 05, 2010

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKprofile_pki: name\version$	name	varchar(50)	50
$Cluster Primary Key XPKprofile_pki: name\version$	version	varchar(50)	50
	profile	varbinary(2000)	2000

Indexes

	Name	Columns	Unique
$Cluster Primary Key XPKprofile_pki: name\version$	XPKprofile_pki	name, version

SQL Script

CREATE TABLE [dbo].[profile_pki]
(
[name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[version] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[profile] [varbinary] (2000) NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[profile_pki] ADD CONSTRAINT [XPKprofile_pki] PRIMARY KEY CLUSTERED ([name], [version]) ON [PRIMARY]
GO

Uses