Tables [dbo].[ca_cic_manager]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count74
Created10:24:08 AM Sunday, December 05, 2010
Last Modified10:24:08 AM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
user_uuidbinary(16)16
No
Cluster Primary Key PK_ca_cic_manager_name: namenamenvarchar(490)980
No
valuenvarchar(512)1024
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_ca_cic_manager_name: namePK_ca_cic_manager_namename
Yes
Permissions
TypeActionOwning Principal
GrantDeletecicuser
GrantInsertcicuser
GrantSelectcicuser
GrantUpdatecicuser
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
GRANT SELECT ON  [dbo].[ca_cic_manager] TO [cicuser]
GRANT INSERT ON  [dbo].[ca_cic_manager] TO [cicuser]
GRANT DELETE ON  [dbo].[ca_cic_manager] TO [cicuser]
GRANT UPDATE ON  [dbo].[ca_cic_manager] TO [cicuser]
GO
Uses