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_Product_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] |
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].[Product_H_S]') AND type IN (N'U')) DROP TABLE [dbo].[Product_H_S] GO CREATE TABLE [dbo].[Product_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 , [ProductNumber] nvarchar(25) NOT NULL , [Color] nvarchar(15) , [StandardCost] money NOT NULL , [ListPrice] money NOT NULL , [Size] nvarchar(5) , [Weight] decimal(8,2) , [SellStartDate] datetime NOT NULL , [SellEndDate] datetime , [DiscontinuedDate] datetime , [ThumbNailPhoto] varbinary(max) , [ThumbnailPhotoFileName] nvarchar(50) , [rowguid] uniqueidentifier NOT NULL , [ModifiedDate] datetime NOT NULL -- Constraints ,CONSTRAINT [PK_Product_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].[Product_H_S] WITH CHECK ADD CONSTRAINT [FK_Product_H_S_Product_H_hub_id] FOREIGN KEY([hub_id]) REFERENCES [dbo].[Product_H] ([hub_id]) GO ALTER TABLE [dbo].[Product_H_S] CHECK CONSTRAINT [FK_Product_H_S_Product_H_hub_id] GO