Tables [dbo].[wtVPM_Datastore]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:46:12 PM Saturday, July 19, 2008
Last Modified2:46:12 PM Saturday, July 19, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
uuidbinary(16)16
No
VPM_Property1varchar(255)255
Yes
VPM_Property2varchar(255)255
Yes
VPM_Property3varchar(255)255
Yes
VPM_Property4varchar(255)255
Yes
VPM_Property5varchar(255)255
Yes
VPM_Property6varchar(255)255
Yes
VPM_Property7varchar(255)255
Yes
VPM_Property8varchar(255)255
Yes
VPM_Property9varchar(255)255
Yes
VPM_Property10varchar(255)255
Yes
VC_ServerNamevarchar(255)255
Yes
DatastoreNamevarchar(255)255
Yes
DatastoreURLvarchar(255)255
Yes
DatastoreFreeSpacevarchar(255)255
Yes
DatastoreMaxFileSizevarchar(255)255
Yes
DatastoreTypevarchar(255)255
Yes
DatastoreMultiHostAccessvarchar(255)255
Yes
DatastoreAccessiblevarchar(255)255
Yes
DatastoreMonitorint4
Yes
DatastoreFreeSpaceAlertint4
Yes
DatastoreFreeSpaceWarnThreshvarchar(255)255
Yes
DatastoreFreeSpaceCritThreshvarchar(255)255
Yes
DatastoreFreeSpaceStateint4
Yes
DatastoreFreeSpaceAccessibleAlint4
Yes
DatastoreFreeSpaceAccessibleStint4
Yes
SQL Script
CREATE TABLE [dbo].[wtVPM_Datastore]
(
[uuid] [binary] (16) NOT NULL,
[VPM_Property1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VC_ServerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreFreeSpace] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreMaxFileSize] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreMultiHostAccess] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreAccessible] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreMonitor] [int] NULL,
[DatastoreFreeSpaceAlert] [int] NULL,
[DatastoreFreeSpaceWarnThresh] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreFreeSpaceCritThresh] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatastoreFreeSpaceState] [int] NULL,
[DatastoreFreeSpaceAccessibleAl] [int] NULL,
[DatastoreFreeSpaceAccessibleSt] [int] NULL
) ON [PRIMARY]
GO
Uses