Tables [dbo].[ai_hfdef_instcnt_kpi]
Properties
PropertyValue
Row Count940
Created11:06:57 AM Wednesday, March 07, 2007
Last Modified11:09:29 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key ai_hfdef_instcnt_kpi_pk: hfuuidhfuuiduniqueidentifier16
No
Indexes ai_hfdef_instcnt_kpi_ak1: countcountint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key ai_hfdef_instcnt_kpi_pk: hfuuidai_hfdef_instcnt_kpi_pkhfuuid
Yes
ai_hfdef_instcnt_kpi_ak1count
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_hfdef_instcnt_kpi]
(
[hfuuid] [uniqueidentifier] NOT NULL,
[count] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_hfdef_instcnt_kpi] ADD CONSTRAINT [ai_hfdef_instcnt_kpi_pk] PRIMARY KEY CLUSTERED ([hfuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_instcnt_kpi_ak1] ON [dbo].[ai_hfdef_instcnt_kpi] ([count] DESC) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_hfdef_instcnt_kpi] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_hfdef_instcnt_kpi] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_hfdef_instcnt_kpi] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_hfdef_instcnt_kpi] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_hfdef_instcnt_kpi] TO [aipublic]
GO
Uses