Tables [dbo].[wtVPM_Template]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:46:13 PM Saturday, July 19, 2008
Last Modified2:46:13 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
TemplateNamevarchar(255)255
Yes
TemplateFolderIDvarchar(255)255
Yes
TemplateFolderNamevarchar(255)255
Yes
TemplateFolderFullPathvarchar(255)255
Yes
TemplateHostNamevarchar(255)255
Yes
TemplateDatacenterNamevarchar(255)255
Yes
TemplateOSTypevarchar(255)255
Yes
TemplateNumVCpuvarchar(255)255
Yes
TemplateMemvarchar(255)255
Yes
TemplateIPAddressvarchar(255)255
Yes
TemplateDatastorevarchar(255)255
Yes
TemplateNetworkvarchar(255)255
Yes
DatacenterNamevarchar(255)255
Yes
VC_ServerNamevarchar(255)255
Yes
ClusterNamevarchar(255)255
Yes
VMServer_Namevarchar(255)255
Yes
DatacenterIndexvarchar(255)255
Yes
ClusterIndexvarchar(255)255
Yes
VMServer_IDvarchar(255)255
Yes
Config_Filevarchar(255)255
Yes
SQL Script
CREATE TABLE [dbo].[wtVPM_Template]
(
[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,
[TemplateName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateFolderID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateFolderName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateFolderFullPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateHostName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateDatacenterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateOSType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateNumVCpu] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateMem] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateIPAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateDatastore] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateNetwork] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatacenterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VC_ServerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClusterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMServer_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatacenterIndex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClusterIndex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMServer_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Config_File] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Uses