[dbo].[ca_cic_manager]

(local) > mdb > Tables > dbo.ca_cic_manager

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	4:35:54 PM Wednesday, March 24, 2010
Last Modified	4:35:54 PM Wednesday, March 24, 2010

Columns

Name	Data Type	Max Length (Bytes)
user_uuid	binary(16)	16
name	nvarchar(490)	980
value	nvarchar(512)	1024

Indexes

	Name	Columns	Unique
	PK_ca_cic_manager_name	name

SQL Script

CREATE TABLE [dbo].[ca_cic_manager]
(
[user_uuid] [binary] (16) NOT NULL,
[name] [nvarchar] (490) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[value] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_cic_manager] ADD CONSTRAINT [PK_ca_cic_manager_name] PRIMARY KEY CLUSTERED ([name]) ON [PRIMARY]
GO

Uses