Varigence, Inc.

ExpandMinimize
AutoGenerate_DV.mst Reference Documentation
_Sql_Deploy_Tables.SEQC - Create Satelites.Create Table AWLT_DV_dbo_Address_H_S 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_Address_H_S
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].[Address_H_S]') AND type IN (N'U')) DROP TABLE [dbo].[Address_H_S] GO CREATE TABLE [dbo].[Address_H_S] ( -- Columns Definition [hub_id] bigint NOT NULL , [load_date] datetime2(7) NOT NULL , [load_date_end] datetime2(7) NOT NULL , [voided] bit NOT NULL , [AddressLine1] nvarchar(60) NOT NULL , [AddressLine2] nvarchar(60) , [City] nvarchar(30) NOT NULL , [StateProvince] nvarchar(50) NOT NULL , [CountryRegion] nvarchar(50) NOT NULL , [PostalCode] nvarchar(15) NOT NULL , [rowguid] uniqueidentifier NOT NULL , [ModifiedDate] datetime NOT NULL -- Constraints ,CONSTRAINT [PK_Address_H_S] PRIMARY KEY CLUSTERED ( [hub_id] Asc,[load_date] Asc) WITH(PAD_INDEX = OFF,IGNORE_DUP_KEY = OFF) ON "default" ) ON "default" WITH (DATA_COMPRESSION = NONE) GO ------------------------------------------------------------------- ALTER TABLE [dbo].[Address_H_S] WITH CHECK ADD CONSTRAINT [FK_Address_H_S_Address_H_hub_id] FOREIGN KEY([hub_id]) REFERENCES [dbo].[Address_H] ([hub_id]) GO ALTER TABLE [dbo].[Address_H_S] CHECK CONSTRAINT [FK_Address_H_S_Address_H_hub_id] GO