Tables [dbo].[ai_swcat_instcnt_kpi]
Properties
PropertyValue
Row Count308
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_swcat_instcnt_kpi_pk: scuuidscuuiduniqueidentifier16
No
Indexes ai_swcat_instcnt_kpi_ak1: countcountint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key ai_swcat_instcnt_kpi_pk: scuuidai_swcat_instcnt_kpi_pkscuuid
Yes
ai_swcat_instcnt_kpi_ak1count
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_swcat_instcnt_kpi]
(
[scuuid] [uniqueidentifier] NOT NULL,
[count] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_swcat_instcnt_kpi] ADD CONSTRAINT [ai_swcat_instcnt_kpi_pk] PRIMARY KEY CLUSTERED ([scuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swcat_instcnt_kpi_ak1] ON [dbo].[ai_swcat_instcnt_kpi] ([count]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_swcat_instcnt_kpi] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_swcat_instcnt_kpi] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_swcat_instcnt_kpi] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_swcat_instcnt_kpi] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_swcat_instcnt_kpi] TO [aipublic]
GO
Uses