Tables [dbo].[CMS_InfoObjects6]
Properties
PropertyValue
HeapYes
Row Count1732
Created1:08:47 PM Thursday, March 25, 2010
Last Modified1:08:47 PM Thursday, March 25, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes ObjectID_I6: ObjectIDObjectIDint4
No
Indexes ParentID_I6: ParentIDParentIDint4
No
Indexes TypeID_I6: TypeIDTypeIDint4
No
Indexes OwnerID_I6: OwnerIDOwnerIDint4
No
Versionint4
No
Indexes LastModifyTime_I6: LastModifyTimeLastModifyTimevarbinary(32)32
No
Indexes ScheduleStatus_I6: ScheduleStatusScheduleStatusint4
Yes
Indexes NextRunTime_I6: NextRunTimeNextRunTimevarbinary(32)32
Yes
CRCvarbinary(30)30
No
Propertiesimagemax
No
Indexes SI_GUID_I6: SI_GUIDSI_GUIDvarbinary(56)56
Yes
Indexes SI_CUID_I6: SI_CUIDSI_CUIDvarbinary(56)56
Yes
Indexes SI_RUID_I6: SI_RUIDSI_RUIDvarbinary(56)56
Yes
Indexes SI_INSTANCE_OBJECT_I6: SI_INSTANCE_OBJECTSI_INSTANCE_OBJECTint4
Yes
Indexes SI_PLUGIN_OBJECT_I6: SI_PLUGIN_OBJECTSI_PLUGIN_OBJECTint4
Yes
Indexes SI_TABLE_I6: SI_TABLESI_TABLEint4
Yes
Indexes SI_HIDDEN_OBJECT_I6: SI_HIDDEN_OBJECTSI_HIDDEN_OBJECTint4
Yes
Indexes SI_NAMEDUSER_I6: SI_NAMEDUSERSI_NAMEDUSERint4
Yes
Indexes SI_RECURRING_I6: SI_RECURRINGSI_RECURRINGint4
Yes
Indexes SI_RUNNABLE_OBJECT_I6: SI_RUNNABLE_OBJECTSI_RUNNABLE_OBJECTint4
Yes
Indexes SI_PSS_SERVICE_ID_I6: SI_PSS_SERVICE_IDSI_PSS_SERVICE_IDint4
Yes
Indexes ObjName_I6: ObjNameObjNamevarbinary(255)255
Yes
Indexes ObjName_TR_I6: ObjName_TRObjName_TRint4
Yes
Indexes SI_KEYWORD_I6: SI_KEYWORDSI_KEYWORDvarbinary(255)255
Yes
Indexes SI_KEYWORD_TR_I6: SI_KEYWORD_TRSI_KEYWORD_TRint4
Yes
Indexes LOV_KEY_I6: LOV_KEYLOV_KEYvarbinary(18)18
Yes
Indexes Indexes
NameColumnsUnique
ObjectID_I6ObjectID
Yes
SI_CUID_I6SI_CUID
Yes
SI_GUID_I6SI_GUID
Yes
LastModifyTime_I6LastModifyTime
LOV_KEY_I6LOV_KEY
NextRunTime_I6NextRunTime
ObjName_I6ObjName
ObjName_TR_I6ObjName_TR
OwnerID_I6OwnerID
ParentID_I6ParentID
ScheduleStatus_I6ScheduleStatus
SI_HIDDEN_OBJECT_I6SI_HIDDEN_OBJECT
SI_INSTANCE_OBJECT_I6SI_INSTANCE_OBJECT
SI_KEYWORD_I6SI_KEYWORD
SI_KEYWORD_TR_I6SI_KEYWORD_TR
SI_NAMEDUSER_I6SI_NAMEDUSER
SI_PLUGIN_OBJECT_I6SI_PLUGIN_OBJECT
SI_PSS_SERVICE_ID_I6SI_PSS_SERVICE_ID
SI_RECURRING_I6SI_RECURRING
SI_RUID_I6SI_RUID
SI_RUNNABLE_OBJECT_I6SI_RUNNABLE_OBJECT
SI_TABLE_I6SI_TABLE
TypeID_I6TypeID
SQL Script
CREATE TABLE [dbo].[CMS_InfoObjects6]
(
[ObjectID] [int] NOT NULL,
[ParentID] [int] NOT NULL,
[TypeID] [int] NOT NULL,
[OwnerID] [int] NOT NULL,
[Version] [int] NOT NULL,
[LastModifyTime] [varbinary] (32) NOT NULL,
[ScheduleStatus] [int] NULL,
[NextRunTime] [varbinary] (32) NULL,
[CRC] [varbinary] (30) NOT NULL,
[Properties] [image] NOT NULL,
[SI_GUID] [varbinary] (56) NULL,
[SI_CUID] [varbinary] (56) NULL,
[SI_RUID] [varbinary] (56) NULL,
[SI_INSTANCE_OBJECT] [int] NULL,
[SI_PLUGIN_OBJECT] [int] NULL,
[SI_TABLE] [int] NULL,
[SI_HIDDEN_OBJECT] [int] NULL,
[SI_NAMEDUSER] [int] NULL,
[SI_RECURRING] [int] NULL,
[SI_RUNNABLE_OBJECT] [int] NULL,
[SI_PSS_SERVICE_ID] [int] NULL,
[ObjName] [varbinary] (255) NULL,
[ObjName_TR] [int] NULL,
[SI_KEYWORD] [varbinary] (255) NULL,
[SI_KEYWORD_TR] [int] NULL,
[LOV_KEY] [varbinary] (18) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [LastModifyTime_I6] ON [dbo].[CMS_InfoObjects6] ([LastModifyTime]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [LOV_KEY_I6] ON [dbo].[CMS_InfoObjects6] ([LOV_KEY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NextRunTime_I6] ON [dbo].[CMS_InfoObjects6] ([NextRunTime]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [ObjectID_I6] ON [dbo].[CMS_InfoObjects6] ([ObjectID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ObjName_I6] ON [dbo].[CMS_InfoObjects6] ([ObjName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ObjName_TR_I6] ON [dbo].[CMS_InfoObjects6] ([ObjName_TR]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [OwnerID_I6] ON [dbo].[CMS_InfoObjects6] ([OwnerID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ParentID_I6] ON [dbo].[CMS_InfoObjects6] ([ParentID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ScheduleStatus_I6] ON [dbo].[CMS_InfoObjects6] ([ScheduleStatus]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [SI_CUID_I6] ON [dbo].[CMS_InfoObjects6] ([SI_CUID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [SI_GUID_I6] ON [dbo].[CMS_InfoObjects6] ([SI_GUID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_HIDDEN_OBJECT_I6] ON [dbo].[CMS_InfoObjects6] ([SI_HIDDEN_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_INSTANCE_OBJECT_I6] ON [dbo].[CMS_InfoObjects6] ([SI_INSTANCE_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_KEYWORD_I6] ON [dbo].[CMS_InfoObjects6] ([SI_KEYWORD]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_KEYWORD_TR_I6] ON [dbo].[CMS_InfoObjects6] ([SI_KEYWORD_TR]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_NAMEDUSER_I6] ON [dbo].[CMS_InfoObjects6] ([SI_NAMEDUSER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_PLUGIN_OBJECT_I6] ON [dbo].[CMS_InfoObjects6] ([SI_PLUGIN_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_PSS_SERVICE_ID_I6] ON [dbo].[CMS_InfoObjects6] ([SI_PSS_SERVICE_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_RECURRING_I6] ON [dbo].[CMS_InfoObjects6] ([SI_RECURRING]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_RUID_I6] ON [dbo].[CMS_InfoObjects6] ([SI_RUID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_RUNNABLE_OBJECT_I6] ON [dbo].[CMS_InfoObjects6] ([SI_RUNNABLE_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_TABLE_I6] ON [dbo].[CMS_InfoObjects6] ([SI_TABLE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [TypeID_I6] ON [dbo].[CMS_InfoObjects6] ([TypeID]) ON [PRIMARY]
GO
Uses