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_SalesOrderDetail_Product_L_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] |
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].[SalesOrderDetail_Product_L_S]') AND type IN (N'U')) DROP TABLE [dbo].[SalesOrderDetail_Product_L_S] GO CREATE TABLE [dbo].[SalesOrderDetail_Product_L_S] ( -- Columns Definition [link_id] bigint NOT NULL , [load_date] datetime2(7) NOT NULL , [load_date_end] datetime2(7) NOT NULL , [voided] bit NOT NULL -- Constraints ,CONSTRAINT [PK_SalesOrderDetail_Product_L_S] PRIMARY KEY CLUSTERED ( [link_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].[SalesOrderDetail_Product_L_S] WITH CHECK ADD CONSTRAINT [FK_SalesOrderDetail_Product_L_S_SalesOrderDetail_L_link_id] FOREIGN KEY([link_id]) REFERENCES [dbo].[SalesOrderDetail_Product_L] ([link_id]) GO ALTER TABLE [dbo].[SalesOrderDetail_Product_L_S] CHECK CONSTRAINT [FK_SalesOrderDetail_Product_L_S_SalesOrderDetail_L_link_id] GO