# Varigence, Inc.

- AutoGenerate_DV.mst
  - Connections (2)
  - Schemas (2)
  - Tables (49)
  - Packages (1)
  - Databases (2)

AutoGenerate_DV.mst Reference Documentation
_Sql_Deploy_Tables.SEQC - Create Satelites.Create Table AWLT_DV_dbo_ProductCategory_H_S Execute SQLTask
Detailed Property Settings

| Name | Default
--- | --- | ---
| Annotations | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.AstAnnotationNode]
| BypassPrepare | True
| BypassPrepareDefaultValue |
| CodePage | 1252
| CodePageDefaultValue |
| Connection | AWLT_DV
| DelayValidation | False
| Disabled | False
| DisableEventHandlers | False
| Events | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstTaskEventHandlerNode]
| ExecutionValueVariable |
| Expressions | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstPropertyExpressionNode]
| FailPackageOnFailure | False
| FailParentOnFailure | False
| ForcedExecutionValue | 0
| ForcedExecutionValueDataType | Int32
| ForceExecutionResult | None
| ForceExecutionValue | False
| FriendlyTypeNameStatic |
| Id | 00000000-0000-0000-0000-000000000000
| ImportedScopeChildren |
| IsInBrokenLiveBimlScript |
| IsolationLevel | Serializable
| IsStoredProcedure | False
| IsStoredProcedureDefaultValue |
| Language | Inherited
| LogEvents | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstLogEventNode]
| LoggingMode | Inherit
| LogProviders | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.LogProvider.AstLogProviderBaseNode]
| MaximumErrorCount | 1
| Name | Create Table AWLT_DV_dbo_ProductCategory_H_S
| ObjectTag |
| Parameters | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstExecuteSqlParameterMappingTypeNode]
| PrecedenceConstraints |
| Results | Varigence.Utility.Collections.VulcanCollection`1[Varigence.Languages.Biml.Task.AstVariableParameterMappingNode]
| ResultSet | None
| ResultSetDefaultValue |
| SqlCommand | Varigence.Languages.Biml.Task.AstDirectResourceNode
| Timeout | 0
| TimeoutDefaultValue |
| TransactionMode | Join
| Variables | Varigence.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].[ProductCategory_H_S]') AND type IN (N'U')) DROP TABLE [dbo].[ProductCategory_H_S] GO CREATE TABLE [dbo].[ProductCategory_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 , [Name] nvarchar(50) NOT NULL , [rowguid] uniqueidentifier NOT NULL , [ModifiedDate] datetime NOT NULL -- Constraints ,CONSTRAINT [PK_ProductCategory_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].[ProductCategory_H_S] WITH CHECK ADD CONSTRAINT [FK_ProductCategory_H_S_ProductCategory_H_hub_id] FOREIGN KEY([hub_id]) REFERENCES [dbo].[ProductCategory_H] ([hub_id]) GO ALTER TABLE [dbo].[ProductCategory_H_S] CHECK CONSTRAINT [FK_ProductCategory_H_S_ProductCategory_H_hub_id] GO