Tables [dbo].[ai_swdef_instcnt_kpi]
Properties
PropertyValue
Row Count2768
Created11:06:58 AM Wednesday, March 07, 2007
Last Modified11:09:30 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key ai_swdef_instcnt_kpi_pk: swuuidswuuiduniqueidentifier16
No
Indexes ai_swdef_instcnt_kpi_ak1: countcountint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key ai_swdef_instcnt_kpi_pk: swuuidai_swdef_instcnt_kpi_pkswuuid
Yes
ai_swdef_instcnt_kpi_ak1count
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_swdef_instcnt_kpi]
(
[swuuid] [uniqueidentifier] NOT NULL,
[count] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_swdef_instcnt_kpi] ADD CONSTRAINT [ai_swdef_instcnt_kpi_pk] PRIMARY KEY CLUSTERED ([swuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_instcnt_kpi_ak1] ON [dbo].[ai_swdef_instcnt_kpi] ([count]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_swdef_instcnt_kpi] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_swdef_instcnt_kpi] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_swdef_instcnt_kpi] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_swdef_instcnt_kpi] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_swdef_instcnt_kpi] TO [aipublic]
GO
Uses
Used By