Database reference - AdventureWorks

AdventureWorks -  defaults

Defaults overview

namecommentbindings
DF_AWBuildVersion_ModifiedDateDefault constraint value of GETDATE()  1
DF_ErrorLog_ErrorTimeDefault constraint value of GETDATE()  1
DF_Department_ModifiedDateDefault constraint value of GETDATE()  1
DF_Employee_CurrentFlagDefault constraint value of 1  1
DF_Employee_ModifiedDateDefault constraint value of GETDATE()  1
DF_Employee_rowguidDefault constraint value of NEWID()  1
DF_Employee_SalariedFlagDefault constraint value of 1 (TRUE)  1
DF_Employee_SickLeaveHoursDefault constraint value of 0  1
DF_Employee_VacationHoursDefault constraint value of 0  1
DF_EmployeeAddress_ModifiedDateDefault constraint value of GETDATE()  1
DF_EmployeeAddress_rowguidDefault constraint value of NEWID()  1
DF_EmployeeDepartmentHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_EmployeePayHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_JobCandidate_ModifiedDateDefault constraint value of GETDATE()  1
DF_Shift_ModifiedDateDefault constraint value of GETDATE()  1
DF_Address_ModifiedDateDefault constraint value of GETDATE()  1
DF_Address_rowguidDefault constraint value of NEWID()  1
DF_AddressType_ModifiedDateDefault constraint value of GETDATE()  1
DF_AddressType_rowguidDefault constraint value of NEWID()  1
DF_Contact_EmailPromotionDefault constraint value of 0  1
DF_Contact_ModifiedDateDefault constraint value of GETDATE()  1
DF_Contact_NameStyleDefault constraint value of 0  1
DF_Contact_rowguidDefault constraint value of NEWID()  1
DF_ContactType_ModifiedDateDefault constraint value of GETDATE()  1
DF_CountryRegion_ModifiedDateDefault constraint value of GETDATE()  1
DF_StateProvince_IsOnlyStateProvinceFlagDefault constraint value of 1 (TRUE)  1
DF_StateProvince_ModifiedDateDefault constraint value of GETDATE()  1
DF_StateProvince_rowguidDefault constraint value of NEWID()  1
DF_BillOfMaterials_ModifiedDateDefault constraint value of GETDATE()  1
DF_BillOfMaterials_PerAssemblyQtyDefault constraint value of 1.0  1
DF_BillOfMaterials_StartDateDefault constraint value of GETDATE()  1
DF_Culture_ModifiedDateDefault constraint value of GETDATE()  1
DF_Document_ChangeNumberDefault constraint value of 0  1
DF_Document_ModifiedDateDefault constraint value of GETDATE()  1
DF_Illustration_ModifiedDateDefault constraint value of GETDATE()  1
DF_Location_AvailabilityDefault constraint value of 0.00  1
DF_Location_CostRateDefault constraint value of 0.0  1
DF_Location_ModifiedDateDefault constraint value of GETDATE()  1
DF_Product_FinishedGoodsFlagDefault constraint value of 1  1
DF_Product_MakeFlagDefault constraint value of 1  1
DF_Product_ModifiedDateDefault constraint value of GETDATE()  1
DF_Product_rowguidDefault constraint value of NEWID()  1
DF_ProductCategory_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductCategory_rowguidDefault constraint value of NEWID()()  1
DF_ProductCostHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductDescription_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductDescription_rowguidDefault constraint value of NEWID()  1
DF_ProductDocument_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductInventory_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductInventory_QuantityDefault constraint value of 0  1
DF_ProductInventory_rowguidDefault constraint value of NEWID()  1
DF_ProductListPriceHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductModel_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductModel_rowguidDefault constraint value of NEWID()  1
DF_ProductModelIllustration_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductModelProductDescriptionCulture_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductPhoto_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductProductPhoto_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductProductPhoto_PrimaryDefault constraint value of 0 (FALSE)  1
DF_ProductReview_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductReview_ReviewDateDefault constraint value of GETDATE()  1
DF_ProductSubcategory_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductSubcategory_rowguidDefault constraint value of NEWID()  1
DF_ScrapReason_ModifiedDateDefault constraint value of GETDATE()  1
DF_TransactionHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_TransactionHistory_ReferenceOrderLineIDDefault constraint value of 0  1
DF_TransactionHistory_TransactionDateDefault constraint value of GETDATE()  1
DF_TransactionHistoryArchive_ModifiedDateDefault constraint value of GETDATE()  1
DF_TransactionHistoryArchive_ReferenceOrderLineIDDefault constraint value of 0  1
DF_TransactionHistoryArchive_TransactionDateDefault constraint value of GETDATE()  1
DF_UnitMeasure_ModifiedDateDefault constraint value of GETDATE()  1
DF_WorkOrder_ModifiedDateDefault constraint value of GETDATE()  1
DF_WorkOrderRouting_ModifiedDateDefault constraint value of GETDATE()  1
DF_ProductVendor_ModifiedDateDefault constraint value of GETDATE()  1
DF_PurchaseOrderDetail_ModifiedDateDefault constraint value of GETDATE()  1
DF_PurchaseOrderHeader_FreightDefault constraint value of 0.0  1
DF_PurchaseOrderHeader_ModifiedDateDefault constraint value of GETDATE()  1
DF_PurchaseOrderHeader_OrderDateDefault constraint value of GETDATE()  1
DF_PurchaseOrderHeader_RevisionNumberDefault constraint value of 0  1
DF_PurchaseOrderHeader_StatusDefault constraint value of 1  1
DF_PurchaseOrderHeader_SubTotalDefault constraint value of 0.0  1
DF_PurchaseOrderHeader_TaxAmtDefault constraint value of 0.0  1
DF_ShipMethod_ModifiedDateDefault constraint value of GETDATE()  1
DF_ShipMethod_rowguidDefault constraint value of NEWID()  1
DF_ShipMethod_ShipBaseDefault constraint value of 0.0  1
DF_ShipMethod_ShipRateDefault constraint value of 0.0  1
DF_Vendor_ActiveFlagDefault constraint value of 1 (TRUE)  1
DF_Vendor_ModifiedDateDefault constraint value of GETDATE()  1
DF_Vendor_PreferredVendorStatusDefault constraint value of 1 (TRUE)  1
DF_VendorAddress_ModifiedDateDefault constraint value of GETDATE()  1
DF_VendorContact_ModifiedDateDefault constraint value of GETDATE()  1
DF_ContactCreditCard_ModifiedDateDefault constraint value of GETDATE()  1
DF_CountryRegionCurrency_ModifiedDateDefault constraint value of GETDATE()  1
DF_CreditCard_ModifiedDateDefault constraint value of GETDATE()  1
DF_Currency_ModifiedDateDefault constraint value of GETDATE()  1
DF_CurrencyRate_ModifiedDateDefault constraint value of GETDATE()  1
DF_Customer_ModifiedDateDefault constraint value of GETDATE()  1
DF_Customer_rowguidDefault constraint value of NEWID()  1
DF_CustomerAddress_ModifiedDateDefault constraint value of GETDATE()  1
DF_CustomerAddress_rowguidDefault constraint value of NEWID()  1
DF_Individual_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesOrderDetail_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesOrderDetail_rowguidDefault constraint value of NEWID()  1
DF_SalesOrderDetail_UnitPriceDiscountDefault constraint value of 0.0  1
DF_SalesOrderHeader_FreightDefault constraint value of 0.0  1
DF_SalesOrderHeader_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesOrderHeader_OnlineOrderFlagDefault constraint value of 1 (TRUE)  1
DF_SalesOrderHeader_OrderDateDefault constraint value of GETDATE()  1
DF_SalesOrderHeader_RevisionNumberDefault constraint value of 0  1
DF_SalesOrderHeader_rowguidDefault constraint value of NEWID()  1
DF_SalesOrderHeader_StatusDefault constraint value of 1  1
DF_SalesOrderHeader_SubTotalDefault constraint value of 0.0  1
DF_SalesOrderHeader_TaxAmtDefault constraint value of 0.0  1
DF_SalesOrderHeaderSalesReason_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesPerson_BonusDefault constraint value of 0.0  1
DF_SalesPerson_CommissionPctDefault constraint value of 0.0  1
DF_SalesPerson_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesPerson_rowguidDefault constraint value of NEWID()  1
DF_SalesPerson_SalesLastYearDefault constraint value of 0.0  1
DF_SalesPerson_SalesYTDDefault constraint value of 0.0  1
DF_SalesPersonQuotaHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesPersonQuotaHistory_rowguidDefault constraint value of NEWID()  1
DF_SalesReason_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesTaxRate_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesTaxRate_rowguidDefault constraint value of NEWID()  1
DF_SalesTaxRate_TaxRateDefault constraint value of 0.0  1
DF_SalesTerritory_CostLastYearDefault constraint value of 0.0  1
DF_SalesTerritory_CostYTDDefault constraint value of 0.0  1
DF_SalesTerritory_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesTerritory_rowguidDefault constraint value of NEWID()  1
DF_SalesTerritory_SalesLastYearDefault constraint value of 0.0  1
DF_SalesTerritory_SalesYTDDefault constraint value of 0.0  1
DF_SalesTerritoryHistory_ModifiedDateDefault constraint value of GETDATE()  1
DF_SalesTerritoryHistory_rowguidDefault constraint value of NEWID()  1
DF_ShoppingCartItem_DateCreatedDefault constraint value of GETDATE()  1
DF_ShoppingCartItem_ModifiedDateDefault constraint value of GETDATE()  1
DF_ShoppingCartItem_QuantityDefault constraint value of 1  1
DF_SpecialOffer_DiscountPctDefault constraint value of 0.0  1
DF_SpecialOffer_MinQtyDefault constraint value of 0.0  1
DF_SpecialOffer_ModifiedDateDefault constraint value of GETDATE()  1
DF_SpecialOffer_rowguidDefault constraint value of NEWID()  1
DF_SpecialOfferProduct_ModifiedDateDefault constraint value of GETDATE()  1
DF_SpecialOfferProduct_rowguidDefault constraint value of NEWID()  1
DF_Store_ModifiedDateDefault constraint value of GETDATE()  1
DF_Store_rowguidDefault constraint value of NEWID()  1
DF_StoreContact_ModifiedDateDefault constraint value of GETDATE()  1
DF_StoreContact_rowguidDefault constraint value of NEWID()  1

Powered by Yoyodyne © 1971