Tables [dbo].[ci_ambiguity_ci]
Properties
PropertyValue
Row Count27
Created4:35:59 PM Wednesday, March 24, 2010
Last Modified4:35:59 PM Wednesday, March 24, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ci_ambiguity_ci: ididbinary(16)16
No
last_update_dateint4
Yes
Indexes ci_ambiguity_ci_x01: ambiguityambiguityint4
Yes
count_resource_nameint4
Yes
count_serial_numberint4
Yes
count_dns_nameint4
Yes
count_mac_addressint4
Yes
count_resource_tagint4
Yes
count_host_nameint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_ci_ambiguity_ci: idPK_ci_ambiguity_ciid
Yes
ci_ambiguity_ci_x01ambiguity
Permissions
TypeActionOwning Principal
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
Extended Properties
NameValue
CommentAdded r12.5
SQL Script
CREATE TABLE [dbo].[ci_ambiguity_ci]
(
[id] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[ambiguity] [int] NULL,
[count_resource_name] [int] NULL,
[count_serial_number] [int] NULL,
[count_dns_name] [int] NULL,
[count_mac_address] [int] NULL,
[count_resource_tag] [int] NULL,
[count_host_name] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ci_ambiguity_ci] ADD CONSTRAINT [PK_ci_ambiguity_ci] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ci_ambiguity_ci_x01] ON [dbo].[ci_ambiguity_ci] ([ambiguity]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ci_ambiguity_ci] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12.5', 'SCHEMA', N'dbo', 'TABLE', N'ci_ambiguity_ci', NULL, NULL
GO
Uses