Tables [dbo].[kpi_infer_summary_docs]
Properties
PropertyValue
Row Count0
Created2:23:20 PM Friday, March 21, 2008
Last Modified2:23:21 PM Friday, March 21, 2008
Columns
NameData TypeCollationMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKkpi_infer_summary_docs: raw_keyIndexes kpi_infer_summary_docs_idx1: log_date\raw_keyraw_keybinary(17)17
No
in_processchar(1)SQL_Latin1_General_CP1_CI_AS1
No
Indexes kpi_infer_summary_docs_idx1: log_date\raw_keylog_datedatetime8
No
msgtextSQL_Latin1_General_CP1_CS_ASmax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKkpi_infer_summary_docs: raw_keyXPKkpi_infer_summary_docsraw_key
Yes
kpi_infer_summary_docs_idx1log_date, raw_key
Permissions
TypeActionOwning Principal
GrantDeleteaionadmin_group
GrantInsertaionadmin_group
GrantSelectaionadmin_group
GrantUpdateaionadmin_group
SQL Script
CREATE TABLE [dbo].[kpi_infer_summary_docs]
(
[raw_key] [binary] (17) NOT NULL,
[in_process] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[log_date] [datetime] NOT NULL,
[msg] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[kpi_infer_summary_docs] ADD CONSTRAINT [XPKkpi_infer_summary_docs] PRIMARY KEY CLUSTERED ([raw_key]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kpi_infer_summary_docs_idx1] ON [dbo].[kpi_infer_summary_docs] ([log_date], [raw_key]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[kpi_infer_summary_docs] TO [aionadmin_group]
GRANT INSERT ON  [dbo].[kpi_infer_summary_docs] TO [aionadmin_group]
GRANT DELETE ON  [dbo].[kpi_infer_summary_docs] TO [aionadmin_group]
GRANT UPDATE ON  [dbo].[kpi_infer_summary_docs] TO [aionadmin_group]
GO
Uses