Varigence, Inc.

ExpandMinimize
AutoGenerate_DV.mst Reference Documentation
_Sql_Deploy_Tables.SEQC - Create Links.Create Table AWLT_DV_dbo_SalesOrderHeader_Customer_L Execute SQLTask
Detailed Property Settings
 NameDefault
AnnotationsVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.AstAnnotationNode]
BypassPrepareTrue
BypassPrepareDefaultValue 
CodePage1252
CodePageDefaultValue 
ConnectionAWLT_DV
DelayValidationFalse
DisabledFalse
DisableEventHandlersFalse
EventsVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstTaskEventHandlerNode]
ExecutionValueVariable 
ExpressionsVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstPropertyExpressionNode]
FailPackageOnFailureFalse
FailParentOnFailureFalse
ForcedExecutionValue0
ForcedExecutionValueDataTypeInt32
ForceExecutionResultNone
ForceExecutionValueFalse
FriendlyTypeNameStatic 
Id00000000-0000-0000-0000-000000000000
ImportedScopeChildren 
IsInBrokenLiveBimlScript 
IsolationLevelSerializable
IsStoredProcedureFalse
IsStoredProcedureDefaultValue 
LanguageInherited
LogEventsVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstLogEventNode]
LoggingModeInherit
LogProvidersVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.LogProvider.AstLogProviderBaseNode]
MaximumErrorCount1
NameCreate Table AWLT_DV_dbo_SalesOrderHeader_Customer_L
ObjectTag 
ParametersVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstExecuteSqlParameterMappingTypeNode]
PrecedenceConstraints 
ResultsVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstVariableParameterMappingNode]
ResultSetNone
ResultSetDefaultValue 
SqlCommandVarigence.Languages.Biml.Task.AstDirectResourceNode
Timeout0
TimeoutDefaultValue 
TransactionModeJoin
VariablesVarigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstVariableNode]
SqlCommand Members

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'dbo') EXEC ('CREATE SCHEMA [dbo] AUTHORIZATION [dbo]') SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO ------------------------------------------------------------------- IF EXISTS (SELECT * from sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SalesOrderHeader_Customer_L]') AND type IN (N'U')) DROP TABLE [dbo].[SalesOrderHeader_Customer_L] GO CREATE TABLE [dbo].[SalesOrderHeader_Customer_L] ( -- Columns Definition [link_id] bigint IDENTITY(1,1) NOT NULL , [SalesOrderHeader_hub_id] bigint NOT NULL , [Customer_hub_id] bigint NOT NULL -- Constraints ,CONSTRAINT [PK_SalesOrderHeader_Customer_L] PRIMARY KEY CLUSTERED ( [link_id] Asc) WITH(PAD_INDEX = OFF,IGNORE_DUP_KEY = OFF) ON "default" ,CONSTRAINT [UIX_SalesOrderHeader_Customer_L] UNIQUE NONCLUSTERED ( [SalesOrderHeader_hub_id] Asc,[Customer_hub_id] Asc) WITH(PAD_INDEX = OFF,IGNORE_DUP_KEY = OFF) ON "default" ) ON "default" WITH (DATA_COMPRESSION = NONE) GO ------------------------------------------------------------------- ALTER TABLE [dbo].[SalesOrderHeader_Customer_L] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Customer_L_SalesOrderHeader_H_hub_id] FOREIGN KEY([SalesOrderHeader_hub_id]) REFERENCES [dbo].[SalesOrderHeader_H] ([hub_id]) GO ALTER TABLE [dbo].[SalesOrderHeader_Customer_L] CHECK CONSTRAINT [FK_SalesOrderHeader_Customer_L_SalesOrderHeader_H_hub_id] GO ALTER TABLE [dbo].[SalesOrderHeader_Customer_L] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Customer_L_Customer_H_hub_id] FOREIGN KEY([Customer_hub_id]) REFERENCES [dbo].[Customer_H] ([hub_id]) GO ALTER TABLE [dbo].[SalesOrderHeader_Customer_L] CHECK CONSTRAINT [FK_SalesOrderHeader_Customer_L_Customer_H_hub_id] GO