Tables [dbo].[ai_osdef_instcnt_kpi]
Properties
PropertyValue
Row Count48
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_osdef_instcnt_kpi_pk: osuuidosuuiduniqueidentifier16
No
Indexes ai_osdef_instcnt_kpi_ak1: countcountint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key ai_osdef_instcnt_kpi_pk: osuuidai_osdef_instcnt_kpi_pkosuuid
Yes
ai_osdef_instcnt_kpi_ak1count
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_osdef_instcnt_kpi]
(
[osuuid] [uniqueidentifier] NOT NULL,
[count] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_osdef_instcnt_kpi] ADD CONSTRAINT [ai_osdef_instcnt_kpi_pk] PRIMARY KEY CLUSTERED ([osuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_instcnt_kpi_ak1] ON [dbo].[ai_osdef_instcnt_kpi] ([count] DESC) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_osdef_instcnt_kpi] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_osdef_instcnt_kpi] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_osdef_instcnt_kpi] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_osdef_instcnt_kpi] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_osdef_instcnt_kpi] TO [aipublic]
GO
Uses